Conditional formatting question?

[Ed]

I tried to set two conditional formats across the same range of cells using
Format >> Conditional Formatting. I tried to set Formula Is =MAX(U5:AB5),
font = red, and Formula Is =MIN(U5:AB5), font = green. The font in all
cells turned red! What would be the correct way to do this?

Ed

 

[Trevor Shuttleworth]

Try:

Formula Is =U5=MAX(U5:AB5) and copy the formatting across

The problem is that by using Formula is, you need to give it a cell/value to
compare to the maximum or minimum to give you the TRUE condition

You could probably get away with Cell Value Is: Equal To: =MAX($U$5:$AB$5)
and make sure you don't get any quotes round the formula

Regards

Trevor

 

[Ed]

Thank you, Trevor. The

Cell Value Is: Equal To: =MAX($U$5:$AB$5)

worked for me.

Ed

 

[Trevor Shuttleworth]

You're welcome ... Thanks for the feedback

Thank you, Trevor. The
worked for me.

Ed