Conditional Formatting with multiple values

[JacJ01]

I am setting up a s/sheet to keep track of meetings, if they were held, minutes received and attendance.

I have set up formulas to give me the status. I want the status cell to change colour depending on its value. I would like

Cancelled – Red (Got this set up already)
Waiting for minutes – Orange (Got this set up already)

The next bit is where I’m having trouble, I would like

If column H contains “Complete” and column E is “Yes” then Blue
If column H contains “Complete” and column E is “No” then Green

I’ve tried to use =AND($H:$H="Complete",$E:$E="Yes") but it changes all the blank cells, what am I doing wrong?

Any help would be appreciated

 

[Special-K99]

Select the entire range to be highlighted, e.g. A1:A1000

Conditional Formatting
New Rule
Use a formula to determine...

=(H1="Cancelled")
format as Red

=(H1="Waiting for minutes")
format as Orange

=AND(H1="Complete",E1="Yes")
format as Blue

=AND(H1="Complete",E1="No")
format as Green

 

[JacJ01]

This has worked! Thank you very much, I wasn't selecting 'Use a formula to determine'