Conditional format based on 4 criteria??

[leem]

I'm thinking I want a conditional format but if your knowledge thinks I should achieve my results another way, please let me know

In cell L5, I have averaged H5:K5. What I would like to do is: if F5 = FT and the result in L5 is < 30 shade blue....if f5 = PT and the result in L5 is > 30 green. I have attached a sample.

Thanks in advance for your help and knowledge.

Michelle

[zbor]

Try this for blue:

=AND(F5="FT", L5<30)

And another condition for green:

=AND(F5="PT", L5>30)

[leem]

Perfect...thank you so much for you help and anwering so quickly.

[whatsmyname]

I have a question,

How would you combine these two into one?

Meaning, if Cell F5 equaled "FT" and the value of L5 is below 30 then cell color change to green.

But, if Cell F5 equaled "FT" and the value is above 30 then change the cell color to red?

How would you combine these into one formula?

Sorry, just curious because I have a similar situation but not quite the same.

[zbor]

2. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

[whatsmyname]

2. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Sorry, please disregard my question. I will post another thread. Thank You.