Conditional formating

[Simon]

lets say I want to display a cell C1 with a yellow background if a value of
E1 = 0

How do I apply this to a whole column

so C1..... E1
C2.....E2
.......
C500...E500

I tried Formula but that effects the whole column

 

[Guest]

Highlight all the cells you want to have the Condidional Formatting. Open up
the Condidional Formatting Box. Change it to Formula is.
Then type:
=E1=0

tj

 

[Gord Dibben]

Simon

Do you want the format applied to all of Column C?

You say so in "How do I apply to a whole column".

Then you say "I tried Formula but that effects the whole column"

To apply to whole column......

Select column C and Format>Conditional Formatting>Formula is:

=$E1=0 pick yellow from Format and OK your way out.

To apply just to C500, select that range and follow steps above.


Gord Dibben Excel MVP

 

[David McRitchie]

Change the formula to =$E1=0 then any cell on row 1 can be the active
cell when you enter your formula with column E selected.

It also makes if possible to color the entire row if you want the coloring to
be based on column E, and you would select all cells (Ctrl+A) on the sheet
so that every cell gets a chance at being colored..

Otherwise per the suggestion to use =E1=0 that would be good if
you want to only work with Column E and you have E1 as the active cell
and Column E selected when you enter your formula.

Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

 

[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 !!!

 

[Gord Dibben]

Simon

Yes, you have missed something.

Read my entire posting, especially the part "To apply to whole column"

Also, you have now changed the parameters.....in first post if E1=0, C1
yellow.

Now you state.....if E1=1, C1 yellow

Adjust CF formula to suit your needs.

Gord