Highlighted Cells

[Brenkenathan]

Is there a way to count how many highlighted cells in a row? Thanks for your assistance

 

[Legacy 11779]

What do you mean by "highlighted cells" ?

 

[Brenkenathan]

I have cells that are highlighted because of conditional formating. IF the cell says Future it is highlighted(YELLOW) Is there a way to count the number of highlighted cells?

 

[Legacy 11779]

Have a look at the COUNTIF worksheet function.

Try :-

=COUNTIF(A1:A10,"Future")

 

[Richie(UK)]

Hi,

If you are referring to the interior.colorindex then have a look at this link:

http://www.cpearson.com/excel/colors.htm

EDIT: Just noticed you are using CF - try this one instead:

http://www.cpearson.com/excel/CFColors.htm

HTH

_________________<font color="blue"> «««<font color="red">¤<font color="blue"><font size=+1>Richie</font><font color="red">¤<font color="blue"> »»»</font>

</gif>
This message was edited by Richie(UK) on 2002-11-01 09:57