Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting of Text...
....I know how to apply Conditional Formatting to cells containing numeric
data; is it possible to apply it to cells where the result is textual? For example: =if(a1=5000,"High","Low") In this instance, I would want to conditionally format this cell so that if the result is High, then the text should be bold and red. Thanks in advance. I'm using Excel 2002... |
#2
|
|||
|
|||
Hi
click on the cell choose format / conditional formatting choose cell value is equal to ="high" click the format button set your formatting click OK twice Regards JulieD "Birmangirl" wrote in message ... ...I know how to apply Conditional Formatting to cells containing numeric data; is it possible to apply it to cells where the result is textual? For example: =if(a1=5000,"High","Low") In this instance, I would want to conditionally format this cell so that if the result is High, then the text should be bold and red. Thanks in advance. I'm using Excel 2002... |
#3
|
|||
|
|||
One way:
CF1: Cell value is equal to ="High" Format1: Bold, red In article , "Birmangirl" wrote: ...I know how to apply Conditional Formatting to cells containing numeric data; is it possible to apply it to cells where the result is textual? For example: =if(a1=5000,"High","Low") In this instance, I would want to conditionally format this cell so that if the result is High, then the text should be bold and red. Thanks in advance. I'm using Excel 2002... |
#4
|
|||
|
|||
Great! Thanks for your very prompt replies - just what I wanted.
"Birmangirl" wrote: ...I know how to apply Conditional Formatting to cells containing numeric data; is it possible to apply it to cells where the result is textual? For example: =if(a1=5000,"High","Low") In this instance, I would want to conditionally format this cell so that if the result is High, then the text should be bold and red. Thanks in advance. I'm using Excel 2002... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing conditional formatting when saving | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |