Change font color function?

  • Thread starter Thread starter Pats
  • Start date Start date
P

Pats

Hi there,

In one workbook I have some worksheets. In my 'cover' worksheet, cel
H25 contains the value of function =MAX('Temperature'!B5:I34). On tha
seperate 'Temperature' worksheet, I'd like to highlight that maximu
value to the font color of red.
Anyone can assist me with a function that highlights that value afte
it sees it that it's the Maximum value?

Greatly appreciate any expert assistance.
:confused: Pats
 
See Conditional Formatting in Help.

One way:

Select the range. Choose Format/Conditional Formatting...

CF1: Formula Is =MAX($B$5:$I$34)
Format: Pattern/<choose color>
 
Back
Top