I guess my question was not clear. I want to change the highliting of the
sell, not the cell content. (e.g. IF X=A, "B" with cell highlighted, "B"
winhout cell highlighted.)

"Bernard Liengme" wrote:

Select the cell(s); use Format | Conditional Formatting
In the dialog box you need: Cell Value is Equal to TRUE
The click the Format button in the dialog and open the Pattern tab
Select the fill colour you want
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"George_Sky" wrote in message
...
I want to identify a specific cell by highlighting it with a cell fill
color
when an "if" statement returns a "ture" response. How do I do this?