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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>