Different colours for specific cells.

[Geek Girl 007]

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.

TEST (1).xlsx
	A	B	C	D	E	F	G	H	I	J
1					Total		February
2	Numer	Surname	First name	Activity	NEG	POS	Date	N/P	Date	N/P
3					1	1		P		N
Sheet3

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

 

[etaf]

XL2BB - i didnt get across the Conditional formatting

so

your selecting G3:J3 but you need to setup 2 rules with 2 different selections
otherwise it will just apply the first rule
and colour the cells all the same
then move onto the next rule
andcolour ALL the cells the next rule colour


If i select P in H3, G3 and H3 will go RED
If I select N in J3, I3 and J3 will go GREEN

2 rules need to be setup

first
select G3 and H3
then put
=$H3="P"
exit

then
select I3 and J3
then
$J3="N"
exit

Book6
	A	B	C	D	E	F	G	H	I	J
1
2
3								p		n
4
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I3:J3	Expression	=$J3="N"	text	NO
G3:H3	Expression	=$H3="P"	text	NO

 

[Geek Girl 007]

If i select P in H3, G3 and H3 will go RED
If I select N in J3, I3 and J3 will go GREEN

2 rules need to be setup

first
select G3 and H3
then put
=$H3="P"
exit

then
select I3 and J3
then
$J3="N"
exit

Book6
	A	B	C	D	E	F	G	H	I	J
1
2
3								p		n
4
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I3:J3	Expression	=$J3="N"	text	NO
G3:H3	Expression	=$H3="P"	text	NO

Hi There,
Thank you so much for replying so fast..... I want it to be an either/or i.e.
Whatever I select in cell, either N or P in H3 then G/H would go the corresponding colour.
also Whatever I select in cell, either N or P in J3 then I/J would go the corresponding colour.

Basically I want it to reset per column.
Can this be done??

 

[etaf]

oh, OK , so it depends on which cell you clck the mouse into - is that what you mean , When you "select"
if so then its VBA thats needed , as the trigger is the cell being selected

I dont provide VBA solutions - sorry ,

hopefully another member will help

 

[Geek Girl 007]

oh, OK , so it depends on which cell you clck the mouse into - is that what you mean , When you "select"
if so then its VBA thats needed , as the trigger is the cell being selected

I dont provide VBA solutions - sorry ,

hopefully another member will help

Thank you

 

[Peter_SSs]

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"

It does not look like that is exactly what you did, otherwise you would not have one rule covering 4 cells like this

I followed the steps stated in the quote above and applied red for P and green for N and this is what I got.
Note the four CF rules, two for each pair of columns.

23 02 12.xlsm
	G	H	I	J
2	Date	N/P	Date	N/P
3		P		N
CF3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I3:J3	Expression	=$J3="N"	text	NO
I3:J3	Expression	=$J3="P"	text	NO
G3:H3	Expression	=$H3="N"	text	NO
G3:H3	Expression	=$H3="P"	text	NO

 

[Geek Girl 007]

It does not look like that is exactly what you did, otherwise you would not have one rule covering 4 cells like this

View attachment 85203

I followed the steps stated in the quote above and applied red for P and green for N and this is what I got.
Note the four CF rules, two for each pair of columns.

23 02 12.xlsm
	G	H	I	J
2	Date	N/P	Date	N/P
3		P		N
CF3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I3:J3	Expression	=$J3="N"	text	NO
I3:J3	Expression	=$J3="P"	text	NO
G3:H3	Expression	=$H3="N"	text	NO
G3:H3	Expression	=$H3="P"	text	NO

It didn't work for me, but I realize that I was being too fancy
I found that it was just better to do it this way: