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.