How-to-highlight-max-and-min-value-in-every-month

Conditional formatting formula to highlight max value in every month:

=B2=MAX(IF(MONTH(A2)=MONTH(Date_rng), Close, ""))

Conditional formatting formula to highlight min value in every month:

=B2=MAX(IF(MONTH(A2)=MONTH(Date_rng), Close, ""))

Named ranges
Date_rng (A2:A169)
Close (B2:B169)
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:

IF(logical_test;[value_if:true];[value_if_false])
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)

MIN(number1,[number2])
Returns the smallest number in a set of values. Ignores logical values and text

MAX(number1,[number2],)
Returns the largest value in a set of values. Ignores logical values and text.