Nested formulas in Conditional formatting

[allwrighty]

Good evening,

I was hoping someone could help with using nested formulas in conditional formatting. I have attached a sample of what I have now and need some help completing what I want to accomplish.

What I am looking for is a formula to determine if:
The values in cells C3:AX3 are in between the values in cells AZ3 and BA3
and - if the value in cell BB3=ABC then I want to highlight cells C3:AX3 that meet the criteria in a specific color.

Thank you in advance for your help.

[Crooza]

Try this conditional format but if you want a different colour for each different project listed in column BB you'll need to create a different rule for each project / colour

All of these should apply to the $c$3:$ax$5 range

=AND(C3>=$AZ3,C3<=$BA3,$BB3="ABC") and set to red

=AND(C3>=$AZ3,C3<=$BA3,$BB3="DEF") and set to Blue

=AND(C3>=$AZ3,C3<=$BA3,$BB3="GHI") and set to green

[allwrighty]

Thanks Crooza - Exactly what I needed. Much appreciated.