Conditional formatting

[marksenior]

Hi, probably a really simple answer to this one, but I'm struggling so please help.
I've set up two columns 'power' & 'interest' both these have a yes/no data validation and a red/green conditional formatting set to them.

I want to now set up a scoring matrix that will output a response based on the responses in columns A & B.

The matrix is to the right of the image, for example if A2 is Low and A3 is High, then C2 should automatically become Keep Informed and be highlighted in yellow.

Sorry if this is a rookie question, but it's driving me nuts.

 

[6StringJazzer]

You will need four rules, one for each color. Also I would set up your matrix differently.

$scratch.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Power	Interest	Grading
2	High	High	Manage Closely						Interest
3									Low	High
4							Power	Low	Monitor	Keep Informed
5								High	Keep Satisfied	Manage Closely
Power Interest

Cell Formulas
Range	Formula
C2	C2	=INDEX($I$4:$J$5,MATCH(A2,$H$4:$H$5,0),MATCH(B2,$I$3:$J$3,0))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2	Cell Value	=$J$5	text	NO
C2	Cell Value	=$I$5	text	NO
C2	Cell Value	=$I$4	text	NO
C2	Cell Value	=$J$4	text	NO