Changing colours by conditions

D

duncan79

This has probably been asked a hundred times over but hey...

i want to change the colour of an area based on the contents of one
cell

2 areas,
2 conditions
2 alternating colours

anybody know what expression would i need to use to acheive this???

thanks duncan
 
I

Ian P

You need to use conditional formatting. Select Format>Conditional Fomratting
and then follow the prompts.

HTH

Ian
 
D

duncan79

Thanks, but...

how does this work if the condition the colour relies on is not the
cell whose colour is to be changed

If the area is K14:p33 and the condition is in H13???
 
D

Dave

At the Conditional Formating prompt select "Formula is" and enter =$H$13=1
or whatever the criteria is.

db
 
Top