View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dippy dippy is offline
external usenet poster
 
Posts: 2
Default Highlighting cells if a value is obtained

I have an IF equation and when it fails/brings up a certain value i would
like it to highlight the cell as a color, specifically red. Is this possible?
If so how?

For example.
The equation is
=IF(G11130000, "No Bolt Specification For Carbon Steel", "0")
In the true instance I need that cell to be highlighted to ensure the
operator knows what happened.

Thank you for your help