Getting a cell to fill with color dependent on another cell

[markdwalls]

Hi All,

Any idea's on if there is a formulas that say, if cell contains a certain value or text, then make another cell a certain color.

Thanks in advance,

Mark

 

[JoeMo]

Have a look at Conditional Formatting in Excel Help.