I have a spreadsheet with numbers listed in columns D, F, H & J. I would
like to include conditional formatting so that if D is greater than F, H & J,
it highlights in Green but if D is less than F, H & J, it highlights in Red.
I tried using formula =If((D2F2),(D2H2),(D2J2) as one condition with the
opposite as an additional condition but it highlights the column if it is
greater than any of the other three. I need it to highlight only if it is
greater or less than ALL 3. Any suggestions???

If you want to check for all 3, you need to use And, as in:
=and(d2f2,d2h2,d2j2)

Same for less than all three:
=and(d2<f2,d2<h2,d2<j2)

Regards,
Fred.

"readystate" wrote in message
...
I have a spreadsheet with numbers listed in columns D, F, H & J. I would
like to include conditional formatting so that if D is greater than F, H &
J,
it highlights in Green but if D is less than F, H & J, it highlights in
Red.
I tried using formula =If((D2F2),(D2H2),(D2J2) as one condition with
the
opposite as an additional condition but it highlights the column if it is
greater than any of the other three. I need it to highlight only if it is
greater or less than ALL 3. Any suggestions???

Worked great. I needed to account for cells that were equal (at zero) so I
added an = after the < or . So far, this has been giving the correct
results. I appreciate your assistance.

"Fred Smith" wrote:

If you want to check for all 3, you need to use And, as in:
=and(d2f2,d2h2,d2j2)

Same for less than all three:
=and(d2<f2,d2<h2,d2<j2)

Regards,
Fred.

"readystate" wrote in message
...
I have a spreadsheet with numbers listed in columns D, F, H & J. I would
like to include conditional formatting so that if D is greater than F, H &
J,
it highlights in Green but if D is less than F, H & J, it highlights in
Red.
I tried using formula =If((D2F2),(D2H2),(D2J2) as one condition with
the
opposite as an additional condition but it highlights the column if it is
greater than any of the other three. I need it to highlight only if it is
greater or less than ALL 3. Any suggestions???

Hi,

Try the following formulas:

=D2<MIN(F2,H2,J2)
=D2MAX(F2,H2,J2)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"readystate" wrote:

I have a spreadsheet with numbers listed in columns D, F, H & J. I would
like to include conditional formatting so that if D is greater than F, H & J,
it highlights in Green but if D is less than F, H & J, it highlights in Red.
I tried using formula =If((D2F2),(D2H2),(D2J2) as one condition with the
opposite as an additional condition but it highlights the column if it is
greater than any of the other three. I need it to highlight only if it is
greater or less than ALL 3. Any suggestions???

Glad I could help. Thanks for the feedback.

Fred

"readystate" wrote in message
...
Worked great. I needed to account for cells that were equal (at zero) so
I
added an = after the < or . So far, this has been giving the correct
results. I appreciate your assistance.

"Fred Smith" wrote:

If you want to check for all 3, you need to use And, as in:
=and(d2f2,d2h2,d2j2)

Same for less than all three:
=and(d2<f2,d2<h2,d2<j2)

Regards,
Fred.

"readystate" wrote in message
...
I have a spreadsheet with numbers listed in columns D, F, H & J. I
would
like to include conditional formatting so that if D is greater than F,
H &
J,
it highlights in Green but if D is less than F, H & J, it highlights in
Red.
I tried using formula =If((D2F2),(D2H2),(D2J2) as one condition with
the
opposite as an additional condition but it highlights the column if it
is
greater than any of the other three. I need it to highlight only if it
is
greater or less than ALL 3. Any suggestions???