software

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: www.excelforum.com/member.php...oamp;userid=30833
View this thread: www.excelforum.com/showthread...hreadid=542858You need to use conditional formatting. Select Formatgt;Conditional Fomratting
and then follow the prompts.

HTH

Ian

quot;duncan79quot; wrote:

gt;
gt; This has probably been asked a hundred times over but hey...
gt;
gt; i want to change the colour of an area based on the contents of one
gt; cell
gt;
gt; 2 areas,
gt; 2 conditions
gt; 2 alternating colours
gt;
gt; anybody know what expression would i need to use to acheive this???
gt;
gt; thanks duncan
gt;
gt;
gt; --
gt; duncan79
gt; ------------------------------------------------------------------------
gt; duncan79's Profile: www.excelforum.com/member.php...oamp;userid=30833
gt; View this thread: www.excelforum.com/showthread...hreadid=542858
gt;
gt;


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: www.excelforum.com/member.php...oamp;userid=30833
View this thread: www.excelforum.com/showthread...hreadid=542858At the Conditional Formating prompt select quot;Formula isquot; and enter =$H$13=1
or whatever the criteria is.

db
quot;duncan79quot; gt; wrote in
message ...
gt;
gt; Thanks, but...
gt;
gt; how does this work if the condition the colour relies on is not the
gt; cell whose colour is to be changed
gt;
gt; If the area is K14:P33 and the condition is in H13???
gt;
gt;
gt; --
gt; duncan79
gt; ------------------------------------------------------------------------
gt; duncan79's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30833
gt; View this thread: www.excelforum.com/showthread...hreadid=542858
gt;