I can only set 3 conditions w/ conditional formating but I need 7 different
colors.

Josh

"BruceP" wrote:


Another possibility (without using VBA) is to select the row, then go to
conditional formatting. Then use "formula is"
=ISNUMBER(FIND("0",-absolute cell reference---)). Then Format,
Patterns, choose your color.


--
BruceP
------------------------------------------------------------------------
BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653
View this thread: http://www.excelforum.com/showthread...hreadid=529793