Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating - More then 3 conditioned with formula | Excel Worksheet Functions | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Changing a Formula in Conditional Formatting | Excel Worksheet Functions |