To change the background color of your desired cell: select that cell
then click ToolsConditional Formatting... on the main menu.

In the Conditional Formatting dialog box that opens, choose Formula Is:
and enter this in the formula line:

=B753

click on the Format button, click on the Patterns tab and choose your
desired fill color (with Red fill I also like to change the font color
to Yellow and make it Bold-use the Font tab for this).

click OK twice to exit the CF box.

now, whenever B7 exceeds 53, your cell will change to your selected
format.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=396980