Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using cell reference in a formula instead of the obtained value | Excel Worksheet Functions | |||
Replacing #N/A response when obtained in Lookup function | Excel Worksheet Functions | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
What is Multiple R, it is the first solution obtained in Regressi. | Excel Worksheet Functions | |||
What is Multiple R, it is the first solution obtained in Regressi. | Excel Worksheet Functions |