Changing colours by conditions
 

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


--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=542858

Changing colours by conditions
 

You need to use conditional formatting. Select FormatConditional Fomratting
and then follow the prompts.

HTH

Ian

"duncan79" wrote:


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


--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=542858

Changing colours by conditions
 

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???


--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=542858

Changing colours by conditions
 

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

db
"duncan79" wrote in
message ...

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???


--
duncan79
------------------------------------------------------------------------
duncan79's Profile:
http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=542858