conditional formatting, multiple criteria

L

Lara

First, please pardon my absolute inability to properly explain what I am
about to ask. I know next to nothing (or less) about programming.

I am trying to find out if I can make one cell do conditional formatting,
based on five different sets of criteria. Currently, it is set at the
following (please forgive "layman's terms"):

If F21 is between IU26 and IV26, then change cell and font to green.

This works fine.

What I need it to be able to do is perform the conditional formatting based
on one of the following five sets of criteria:


If F19 is between J29 and K29 and if F21 > K31...
or
If F19 is between K29 and L29 and if F21 > L31…
or
If F19 is between L29 and M29 and if F21 > N31…
or
If F19 is between M29 and N29 and if F21 > O31…
or
If F19>N29 and if F21 > P31…

… then change cell and font to green.


Is this even possible?? And if so, how do I go about making it so?
 
T

topper09er

you could try conditional
formatting-->formula-->=if(or(and(F19<J29,F19>K29,F21>K31),
and(F19<K29,F19>L29....and so on

hope that helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top