Conditional Formatting - If/And Formula

[Admin]

Hi,

Select AA2:AA60,

In CF, the formulas will be..

=AND($E2="B",$AA2>12)

=AND($E2="A",$AA2>12,$AA2<=48)

Now I think you can write the formulas for other conditions.