count highlighted cells
 

Hi,
Is there a formula that can help me the number of highlighted cells in
a row?


--
PASSWORD37
------------------------------------------------------------------------
PASSWORD37's Profile: http://www.excelforum.com/member.php...o&userid=31245
View this thread: http://www.excelforum.com/showthread...hreadid=509199

count highlighted cells
 

Hi!

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

You're better off using the logic behind why the cells are colored to craft
a formula.

For example, the cells are colored if the values are less than 10.

=COUNTIF(A1:J1,"<10")

Biff

"PASSWORD37" wrote
in message ...

Hi,
Is there a formula that can help me the number of highlighted cells in
a row?


--
PASSWORD37
------------------------------------------------------------------------
PASSWORD37's Profile:
http://www.excelforum.com/member.php...o&userid=31245
View this thread: http://www.excelforum.com/showthread...hreadid=509199