Conditional Formatting (Color)

[pandwra14]

How can I change the row section´s color based on other cells´ colors?

More precisely: IF (D6=green AND D7=green AND D8=green), D1 to D5 green

 

[Drrellik]

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2	Name	Hours	Sex	Contract	Business email	Private email	Phone number	Comments	Training 1	Training 2	Training 3	Training 4	Training 5	Training 6	Training 7	Training 8
3	John Smith	80+	m	yes					x		x	x	1		x	x
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:G3	Expression	=$M$3=2	text	NO
M3	Expression	=$M$3=2	text	NO
A3:G3	Expression	=$M$3=3	text	NO
M3	Expression	=$M$3=3	text	NO

 

[Drrellik]

You will have to add an additional argument to the conditional formatting to have the bright colors turned to a lighter color based on B3

Hope that helps you solve without VBA