If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting Not Working As Intended
I have the following Conditional Formatting rules set up. This is the order
they appear in the Conditional Formatting Rules Manager: Rule Format Applies to Cell Value "$H$41" L.Blue =$E$3:$J$3 Cell Value = "$H$41" D.Green =$E$3:$J$3 Cell Value = "$G$41" L.Green =$E$3:$J$3 Cell Value = "$F$41" Yellow =$E$3:$J$3 Cell Value "$F$41" Red =$E$3:$J$3 Cell Value is set to =$E$41. The problem is the affected cells are Red no matter what value $E$41 is (i.e. F41, = F41, = G41, = H41 or H41). The values of E41, F41, G41 and H41 change with each new entry and the formatting SHOULD change accordingly. I tried changing the order but that didn't work either. How do I make these rules apply as intended? |
#2
|
|||
|
|||
Conditional Formatting Not Working As Intended
Bishop wrote:
I have the following Conditional Formatting rules set up. This is the order they appear in the Conditional Formatting Rules Manager: Rule Format Applies to Cell Value "$H$41" L.Blue =$E$3:$J$3 Cell Value = "$H$41" D.Green =$E$3:$J$3 Cell Value = "$G$41" L.Green =$E$3:$J$3 Cell Value = "$F$41" Yellow =$E$3:$J$3 Cell Value "$F$41" Red =$E$3:$J$3 Cell Value is set to =$E$41. The problem is the affected cells are Red no matter what value $E$41 is (i.e. F41, = F41, = G41, = H41 or H41). The values of E41, F41, G41 and H41 change with each new entry and the formatting SHOULD change accordingly. I tried changing the order but that didn't work either. How do I make these rules apply as intended? Maybe get rid of the quotes? |
#3
|
|||
|
|||
Conditional Formatting Not Working As Intended
That's how the information is presented in the Conditional Formatting Rules
Manager. "Glenn" wrote: Bishop wrote: I have the following Conditional Formatting rules set up. This is the order they appear in the Conditional Formatting Rules Manager: Rule Format Applies to Cell Value "$H$41" L.Blue =$E$3:$J$3 Cell Value = "$H$41" D.Green =$E$3:$J$3 Cell Value = "$G$41" L.Green =$E$3:$J$3 Cell Value = "$F$41" Yellow =$E$3:$J$3 Cell Value "$F$41" Red =$E$3:$J$3 Cell Value is set to =$E$41. The problem is the affected cells are Red no matter what value $E$41 is (i.e. F41, = F41, = G41, = H41 or H41). The values of E41, F41, G41 and H41 change with each new entry and the formatting SHOULD change accordingly. I tried changing the order but that didn't work either. How do I make these rules apply as intended? Maybe get rid of the quotes? . |
#4
|
|||
|
|||
Conditional Formatting Not Working As Intended
I see what you mean now. The formatter actually added the quotes when I set
up the conditions. I went and manually removed them and it works now. Thank you! "Glenn" wrote: Bishop wrote: I have the following Conditional Formatting rules set up. This is the order they appear in the Conditional Formatting Rules Manager: Rule Format Applies to Cell Value "$H$41" L.Blue =$E$3:$J$3 Cell Value = "$H$41" D.Green =$E$3:$J$3 Cell Value = "$G$41" L.Green =$E$3:$J$3 Cell Value = "$F$41" Yellow =$E$3:$J$3 Cell Value "$F$41" Red =$E$3:$J$3 Cell Value is set to =$E$41. The problem is the affected cells are Red no matter what value $E$41 is (i.e. F41, = F41, = G41, = H41 or H41). The values of E41, F41, G41 and H41 change with each new entry and the formatting SHOULD change accordingly. I tried changing the order but that didn't work either. How do I make these rules apply as intended? Maybe get rid of the quotes? . |
Thread Tools | |
Display Modes | |
|
|