Conditional formatting formula to highlight max value in every month:
Conditional formatting formula to highlight min value in every month:
What is named ranges?
How to customize the formula to your excel spreadsheet
Change the named ranges.
Download excel sample file for this tutorial.
Highlight max and min value in every month.xls
(Excel 97-2003 Workbook *.xls)
Functions in this article:
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
MONTH(serial_number) returns the month, a number from 1 (January) to 12 (December)
Returns the smallest number in a set of values. Ignores logical values and text
Returns the largest value in a set of values. Ignores logical values and text.