Using conditional formatting under the formatting menu. In the dialog,
change cell value is to Formula is and put in a formula that reacts to the
value in the other cell, producing True or False.

--
Regards,
Tom Ogilvy


"ForensicAccountant" wrote in
message ...
How would I set/change the fill color of one cell of an Excel spreadsheet
based on the value of another cell on the same Excel spreadsheet?