View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default Incorporating Cell color fill in an "if" logical function?

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?