Change it from
="$I$42=Pending"
to
=$I$42="Pending"
--
David Biddulph

"Rob" wrote in message
...
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