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

I guess that my question is unclear. I do not want to change the content of
the cell, just the highlighting of the cell (i.e. If x=A, "B" with cell
highlighted,"B" with cell not highlighted)

"Miguel Zapico" wrote:

You can use Format-conditional formating, select "Formula is", and insert
the condition that evaluates to true/false in the text box.

Hope this helps,
Miguel.

"George_Sky" wrote:

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?