Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Harrisburg, Pennsylvania, USA
    Thanked 0 Times in 0 Posts

    formula for count (excell 2000)

    To all in the know,

    I currently have a group of cells in a row that I have set with conditional formatting. The formatting changes the color of the font to, red, if cell result is under 100% , or green, if 100 % or over. What I would like is to create a formula using COUNT to give me a result of the number of cells that are GREEN in color. Any and all help is greatly appreciated.

    Thank you in advance for the help

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: formula for count (excell 2000)

    The easiest solution is to create a COUNTIF formula that uses the condition itself, not the conditional formatting, for example


    If you really want to use the conditional formatting, see Conditional Formatting Colors on Chip Pearson's website for an example of the non-trivial VBA code needed to do this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts