Conditional Formatting - Comparative Versus Other Cells

  • Thread starter Thread starter readystate
  • Start date Start date
R

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???
 
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.
 
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.
 
Back
Top