Hi,

Sure. In addition you can just select the entire range and define the
condition for the first cells (keeping things relative). Or you can use the
format painter to copy the CF across the row.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Rene" wrote:

Can you auto fill condtioning formatting in excel 2007? fill handle?

Looking to color code an indv cells across rows.
color code a2 if a2 a1*.33

a b c
1 200 100 50
2 25 50 10
200*.33=66 100*.33=33 50*.33=16
no color code color code no color code
25<66 5033 10<16

Or do I need to format each cell a2:z2...

Thanks