Yes.

Instead of "100" type Paid (without quotes) and format red, then Format normally ad green

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"sallu9211" wrote in message oups.com...
|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.
|