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

Highlighting cells if a value is obtained
 

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

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

Highlighting cells if a value is obtained
 

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

Highlighting cells if a value is obtained
 

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