Conditional Formating Formula
 

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

Conditional Formating Formula
 

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

Conditional Formating Formula
 

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

Rob wrote:

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

Conditional Formating Formula
 

THANK YOU SOOOO MUCH!!!

"David Biddulph" wrote:

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

Conditional Formating Formula
 

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

"RichardSchollar" wrote:

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

Rob wrote:

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