Good point. It works fine now....Sorry to waste your time

Ron de Bruin wrote:
No code needed

You can use CF with a formula then because you only use two conditions in each column

Sorry, i'll make it clear this time.
If G1=0 then A1 is red if it doesnt =0, no color
[quoted text clipped - 25 lines]
consecutive cells. Probably be easiest if it just happens when the workbook
is opened. Thanks in advance for any help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200702/1