No code needed

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"brownti via OfficeKB.com" <u31540@uwe wrote in message news:6e7f2554d6ce6@uwe...
Sorry, i'll make it clear this time.
If G1=0 then A1 is red if it doesnt =0, no color
if G2=0 then A2 is red if it doesnt =0, no color
etc.
If H1=0 then B1 is blue if it doesnt =0, no color
If H2=0 then B2 is blue if it doesnt =0, no color
etc.
If I1=0 then C1 is green if it doesnt =0, no color
If I2=0 then C2 is green if it doesnt =0, no color
etc.

Then there are three more columns that act in the same manner. All of these
go on for about 4000 rows. I hope that is more clear.

Ron de Bruin wrote:
Sorry that I not understand you (Dutch people are not so smart)

needs. If B1=0, A1 should be red, if B1 doesnt equal 0, go to next row.

Go to the next row and then ?

I need to use six different colors...

Where do you use these colors then

That doesnt work for me. I dont understand. I feel like i a loop would be
easier, i just cant get it to work. It only has two different conditions it
[quoted text clipped - 24 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