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