How to format cell based on 2 conditions or Dual Conditional Formatting

[WorkingMan]

Hi,

Can, I format A1 Red if A4 = 1 and A5 < 2?

And then format A1 Yellow if A4 = 1 and A5 = 2

 

[Luke M]

Conditional format, custom rules,

Formula 1:

=AND(A4=1,A5<2)

Format red


Formula 2:

=AND(A4=1,A5=2)

Format yellow.

 

[WorkingMan]

thank you

 

[Luke M]

You're welcome, thanks for the feedback. =)