Change your Conditional Format from "Cell Value Is" to "Formula Is", then
enter this formula:

=OR(AND(F19J29,F19<K29,F21K31),AND(F19K29,F19<L 29,F21L31),AND(F19L29,F19<M29,F21N31),AND(F19M 29,F19<N29,F21O31),AND(F19N29,F21P31))

I think this accomplishes what you're looking for.

HTH,
Elkar


"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 F19N29 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