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