Highlighting cells if a value is obtained
In EXCEL 2007:-
Home / Conditional Formatting / New Rule
Which cell are you trying to highlight? G11? or another cell? or both?
In any case you should be able to set up a rule(s) as shown above.
Please hit Yes if my comments have helped.
Thanks.
"dippy" wrote:
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
|