Conditional Formating Formula

[Guest]

Hello,
I'm trying to set some conditional formating and for some reason nothing is
working. Below are the three conditions I'm trying to use.

Condition 1:
$I$42=Pending (Cell turns red)
Condition 2:
$I$42=Preliminary (Cell turns Yellow)
Condition 3:
$I$42=Completed (Cell turns Green)


After I input the desired conditions and I click OK nothing happens and when
I re-check the formula it looks like this...

Condition 1:
="$I$42=Pending" (Cell turns red)
Condition 2:
="$I$42=Preliminary" (Cell turns Yellow)
Condition 3:
="$I$42=Completed"

Am I doing something wrong?

Thanks Much in Advance,
Rob

 

[David Biddulph]

Change it from
="$I$42=Pending"
to
=$I$42="Pending"

 

[RichardSchollar]

Rob

Firstly, are you applying the CF to the cual cell that contains the
values "Pending" etc?
In this case, you don't need to prefix with the cell address (ie so
simply enetering "Pending" would do (w/o the quotes).

If you are applying CF to another range, but dependent on the cells
that will contain "Pending" etc then you need to change to Formula Is
from Value in the CF dialog and you need to start your formulas with an
= sign:

=$I$42="Pending"

Hope this helps!

Richard

 

[Guest]

THANK YOU SOOOO MUCH!!!

Change it from
="$I$42=Pending"
to
=$I$42="Pending"

 

[Guest]

THANK YOU SOOO MUCH!!! It was such a simple fix that I'm a bit embarrased.