conditional formatting, multiple criteria

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?

--
Lara

See reply to previous posting from Elkar. Please don't repeat postings.

"Lara" wrote:

> 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?
>
> --
> Lara

I didn't and don't see a previous post from Elkar. And, I've done multiple
searches.

Apologies all around. I will find my answer elsewhere. Thanks alot. :/
--
Lara


"Toppers" wrote:

> See reply to previous posting from Elkar. Please don't repeat postings.
>
> "Lara" wrote:
>
> > 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?
> >
> > --
> > Lara