Conditional Formatting

[Fester675]

I have 5 columns, headed Q1, Q2, Q3, Q4 and RAG. I need the RAG column to change colour (Red, Amber, Green) based on entries.

Q1 will be populated and no action is required in the RAG column.

When a figure is entered in Q2, if Q2 = Q1 then RAG will be Amber. If Q2 > Q1 then RAG will be Red. If Q2 is < Q1 then RAG will be Green.

When a figure is entered in Q3, if Q3 = Q2 then RAG will be Amber. If Q3 > Q2 then RAG will be Red. If Q3 is < Q2 then RAG will be Green.

When a figure is entered in Q4, if Q4 = Q3 then RAG will be Amber. If Q4 > Q3 then RAG will be Red. If Q4 is < Q3 then RAG will be Green.

Thanks in advance!

 

[Scott T]

Assuming that the numbers are entered in A though D with Q1 in A and Q4 in D. Adjust to match your range
Select the cells you want to conditional format

in conditional formatting use and select your amber formatting. This is three different rules

=AND(A2=B2,A2<>"",C2="",D2="")

=AND(B2=C2,C2<>"",D2="")

=AND(D2=C2,D2<>"")

then for red create three rules

=AND(B2>A2,C2="",D2="")

=AND(C2>B2,D2="")

=AND(D2>C2,D2<>"")

 

[Fester675]

Thank you Scott!!