highlight the cell you want to change colour
Formatconditional formatting
Select Cell Value, select Greater than or equal to, click in next box
and then click on the target value.
Select format and then choose the conditions you want to apply if the
condition is met e.g. font colour, background pattern.
Select OK
If you want more than one conditional format, go back to conditional
formatting, select Add and then repeat
hope this helps
Ed
--
EdMac
------------------------------------------------------------------------
EdMac's Profile:
http://www.excelforum.com/member.php...o&userid=30736
View this thread:
http://www.excelforum.com/showthread...hreadid=522530