View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rene Rene is offline
external usenet poster
 
Posts: 74
Default conditional formatting

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