Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing the Color of a Word in Formula
I have entered this formula: =IF(B5<2000,"WARNING",IF(B52000,"OK"))
I want the word "WARNING" to show up RED and BOLD-TYPED. Is there a way to do this? -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
Hi Rebecca
you can use conditional formatting to do this. Choose the cell with your IF statement in it and then choose format / conditional formatting choose cell value is choose equal to type WARNING click on the FORMAT button set the formatting as you wish click OK twice. BTW What do you want to happen if B5 = 2000, if it is OK then you can simplify your IF statement as =IF(B5<2000,"WARNING","OK") alternatively if you want WARNING change it to =IF(B5<=2000,"WARNING","OK") Cheers JulieD "Rebecca Cribb via OfficeKB.com" wrote in message ... I have entered this formula: =IF(B5<2000,"WARNING",IF(B52000,"OK")) I want the word "WARNING" to show up RED and BOLD-TYPED. Is there a way to do this? -- Message posted via http://www.officekb.com |
#3
|
|||
|
|||
Not within a formula. Only within text or a macro
-- Don Guillett SalesAid Software "Rebecca Cribb via OfficeKB.com" wrote in message ... I have entered this formula: =IF(B5<2000,"WARNING",IF(B52000,"OK")) I want the word "WARNING" to show up RED and BOLD-TYPED. Is there a way to do this? -- Message posted via http://www.officekb.com |
#4
|
|||
|
|||
Hi JulieD
THANKS A BUNCH!!! This worked PERFECTLY! I had never used conditional formatting before -- what have I been missing??? -- Message posted via http://www.officekb.com |
#5
|
|||
|
|||
Hi Rebecca
you're welcome and thanks for the feedback - CF is a very useful little tool isn't it! Cheers JulieD "Rebecca Cribb via OfficeKB.com" wrote in message ... Hi JulieD THANKS A BUNCH!!! This worked PERFECTLY! I had never used conditional formatting before -- what have I been missing??? -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I keep a formula from changing if a row is added or delete. | Excel Discussion (Misc queries) | |||
Can I use TODAY Function in formula without it changing the next . | Excel Discussion (Misc queries) | |||
how can I get a formula into a word document from an excel spread | Excel Worksheet Functions | |||
what is the formula for changing the same cell on different sheet. | Excel Worksheet Functions | |||
Changing a Parameter Of A Formula | Excel Worksheet Functions |