How to use conditional formatting

S

sallu9211

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".


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.
 
N

Niek Otten

Yes.

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.
|
 
D

Dallman Ross

In <[email protected]>,
sallu9211 said:
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".
Click to expand...

In Conditional Formatting, select for the cell value being
"equal to", then type the word "Paid". It will look like this
on the right on the condition:

="Paid"

It appears not to be case-sensitive. If you have other text in the
cell as well, then select "less than or equal to" for the condition
trigger. Now format your condition. Have the font be red if that
condition is true. The default color can be green, or use another
conditional-formatting option.

-dman-
 
Top