Conditional formating

S

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
 
T

tjtjjtjt

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
 
G

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
 
D

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
 
S

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

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
 
Top