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

Select Format | Conditional Formatting...
Formula is =G11130000
Choose a Format
Ok
--
HTH...

Jim Thomlinson


"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

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

dippy

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

Mike Rogers

"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

Hi

Highlight the range of cells where you want the formatting applied
FormatConditional FormattingCell valueNot equal to0
Format choose whatever Font or Background colour you want.

--
Regards
Roger Govier

"dippy" wrote in message
...
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

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

The message was checked by ESET Smart Security.

http://www.eset.com




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

The message was checked by ESET Smart Security.

http://www.eset.com