Max value in column

[Migel]

Hi !
How to have the maximum value in a column marked in color?

[EarnestAl]

Use Conditional Formatting. Let’s say you have a list range A2:A29, select it and click Format > Conditional > Condition > More Rules. In the dialogue than opens

1. Under Condition 1, change Cell Value to Formula is
2. Enter A2=MAX(A$2:A$29) . The Absolute reference is needed otherwise it will select the max for each cell based on a moving range.
3. Apply Style, for this test choose existing style Good or as appropriate… OK out
   ColourMaxValue.ods (11.8 KB)

[karolus]

@EarnestAl

Enter A2=MAX(A$2:A$29

CellValue _ equal to _ MAX(A$2:A$29)
should also work!

[Migel]

That’s totally fire! Thanks!!!