Conditional Formatting - Comparative Versus Other Cells
 

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

Conditional Formatting - Comparative Versus Other Cells
 

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

Conditional Formatting - Comparative Versus Other Cells
 

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

Conditional Formatting - Comparative Versus Other Cells
 

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

Conditional Formatting - Comparative Versus Other Cells
 

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