Need a formula for a conditional formatting of a cell based on another cell's data
Sounds like Conditional Format is what you are looking for.

Select the cell which have to be formatted and choose Format-&gt;Conditional Format in the menu of Excel.

For more information have a look at: use a formula to apply conditional formatting