conditional formatting based on several conditions

[Mandy_84]

Hi All! need a help
Does anyone can help me in following?
I have used conditional formatting with formula =and($A2>=40,$B2="ional"), however it highlights even those which are below 40 and not "ional"....what am I doing wrong?
Thanks in advance!

 

[wideboydixon]

When you edit the conditional formatting, what does it say in the "Applies to" section. Also, can you post any sample data?

WBD

 

[Mandy_84]

When you edit the conditional formatting, what does it say in the "Applies to" section. Also, can you post any sample data?

WBD

well, it doesn't show me "applies to", but only "select a rule type"

 

[wideboydixon]

If you have an existing conditional format, it must apply to a range. What range does it apply to?

WBD

 

[Mandy_84]

If you have an existing conditional format, it must apply to a range. What range does it apply to?

WBD

Two columns, where I have data, as in the formula =and($A2>=40,$B2="ional"). A & B

 

[wideboydixon]

But if you've applied this formula to columns A:B then all rows will be offset by 1 and it won't work as expected. You need to either apply to range $A$2:$B$9999 (or whatever the range is) or change the formula to:

=AND($A1>=40,$B1="ional")

WBD

 

[Mandy_84]

But if you've applied this formula to columns A:B then all rows will be offset by 1 and it won't work as expected. You need to either apply to range $A$2:$B$9999 (or whatever the range is) or change the formula to:

=AND($A1>=40,$B1="ional")

WBD

Right! it works now! Thanks a million times!