conditional formatting

[Simon]

What I want to do is
E1 = 1 C1's background is yellow (else white)
E2 = 1 C2's background is yellow (else white)
.....
E30 =1 C30's background is yellow (else white)

I want the CONDITIONAL format to whole of C column
at the moment it looks like you have to do this Conditional format for each
CELL
unless I've missed something !!!

 

[Joel Green]

You should just be able to enter the formatting into one cell, copy it,
select column C, then paste special -> formats.

HTH,
Joel

 

[Guest]

You can use the autofill and when the options come up for type of fill select
format only. If you don't have the autofill options then use the format
painter which is the paint brush on the toolbar.