Geek Girl 007
Board Regular
- Joined
- Mar 12, 2022
- Messages
- 127
- Office Version
- 2021
- Platform
- Windows
I've set this up to change colour for specific Letters, but I also want it to be for specific Cells, i.e.
If i select P in H3, G3 and H3 will go RED
If I select N in J3, I3 and J3 will go GREEN
I selected the cells G and H 3 and put in this formula in:
=$H3="P"
=$H3="N"
I selected the cells I and J 3 and put in this formula in:
=$J3="P"
=$J3="N"
However it changed all of the formulas to the ones directly above.
If i select P in H3, G3 and H3 will go RED
If I select N in J3, I3 and J3 will go GREEN
I selected the cells G and H 3 and put in this formula in:
=$H3="P"
=$H3="N"
I selected the cells I and J 3 and put in this formula in:
=$J3="P"
=$J3="N"
However it changed all of the formulas to the ones directly above.
Cell Formulas | ||
---|---|---|
Range | Formula | |
E3 | E3 | =COUNTIF(G3:J3,"N") |
F3 | F3 | =COUNTIF(G3:J3,"P") |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
G3:J3 | Expression | =$J3="P" | text | NO |
G3:J3 | Expression | =$J3="N" | text | NO |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
H3 | List | =Text!$A$1:$A$2 |
J3 | List | =Text!$A$1:$A$2 |