Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use conditional formatting
I actually want to use conditional formatting not on the value of CELL
but the text written in the CELL. Is there any way to do as i want. if the cell value is ''equal to" "100" then it appears in "red", if the cell value is ''not equal to" 100 " then it appears in "green". WHT I WANT if the cell value is ''equal to" (the text word Paid) then it appears in "red", if the cell value is ''not equal to" (the text word Paid) then it appears in "green". can it be possible. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |