Conditional format, 2 conditions,

Question

Hello,

I'm trying to use conditional format to activate, only when both conditions are met. I know the formulas to do each one separately, (as shown in the picture), but I want them combined to one rule.

One cell, just has to be the 'Bolt Diameter' =$M$5=1.375

one cell has to fall in between the specified 'Grip' numbers =AND($N$5>=21,$N$5<=25)

Any help would be appreciated!

Answer 1

Hi Greg,

Thanks for posting in the community. We are happy to help you.

For "only when both conditions are met", I assume only when both rules in your screenshot are met, then highlight J4:J7.

If not, please point it out and let us know.

If so, I suggest you try the following formula.

=AND($M$5=1.375,AND($N$5>=21,$N$5<=25))

We look forward to your response. Thanks for your cooperation.

Sincerely,

George | Microsoft Community Moderator

Answer 2

Thank you George! You nailed it!

I swear I tried that formula at one point, but I probably put a comma somewhere it shouldn't have been, lol.

Thanks again,

Greg

Answer 3

Hopefully it attachs this time, lol