Conditional Formatting - Comparative Versus Other Cells

[readystate]

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((D2>F2),(D2>H2),(D2>J2) 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???

 

[Fred Smith]

If you want to check for all 3, you need to use And, as in:
=and(d2>f2,d2>h2,d2>j2)

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

Regards,
Fred.

 

[readystate]

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.

 

[Shane Devenshire]

Hi,

Try the following formulas:

=D2<MIN(F2,H2,J2)
=D2>MAX(F2,H2,J2)

 

[Fred Smith]

Glad I could help. Thanks for the feedback.

Fred