Conditional Formatting - If/And Formula

[Katrina]

Hi there

I have a spreadsheet that I need to conditional format based around certain qualifications.

One of my columns is a 'Classification' column - being A, B, C, or T.

Another of my columns is the number of visits we do to each row of data per calendar year.

I need to highlight my number of visits column based on the classification, and the number of visits (as the number of visits changes with each classifcation.

i.e. If someone is classified as "B", and the number of visits is greater than 12, then I want to code them blue. But is someone is an "A", and the number of visits is between 12 & 48, then they need to be green etc. etc

So I wrote the following formula in the conditional formatting rule, and it didn't come up with an error, but it didn't seem to work either. Can anyone please please help??

=IF($E:$E="A",(AND($AA:$AA>48)))

[Admin]

Hi Katrina,

Welcome to ExcelFox !!

Could you please attach a sample workbook? Feel free to remove any confidential data and put some dummy values.

[Katrina]

Thanks, i've attached a sample now.Excel Fox.xlsx

[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.

[Katrina]

Thank you so much!