Highlighting cells if a value is obtained

  • Thread starter Thread starter dippy
  • Start date Start date
D

dippy

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(G11>130000, "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
 
Select Format | Conditional Formatting...
Formula is =G11>130000
Choose a Format
Ok
 
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

Look into "Conditional formating", found under "Format" in pre xl2007

Mike Rogers
 
Hi

Highlight the range of cells where you want the formatting applied
Format>Conditional Formatting>Cell value>Not equal to>0
Format choose whatever Font or Background colour you want.

--
Regards
Roger Govier

dippy said:
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(G11>130000, "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

__________ Information from ESET Smart Security, version of virus
signature database 4751 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top