Highlight or List Maximum and Minimum Dates

[kc27]

My Excel 2013 worksheet contains many dates formatted like this: 4/16/16 (each of the dates I care about is in its own cell. I would like to be able to check the entire worksheet and highlight the cells that contain the minimum and maximum dates found on that sheet.

The sheet should only contain dates between (and including) a specific date range, for example 3/14/16 to 6/3/16. I would like to be able to quickly identify and highlight the minimum and maximum dates to ensure they fall in this range.

Any ideas or suggestions on how to accomplish this would be appreciated.

 

[SkipVought]

HI,

Use the MIN() & MAX() functions in the Conditional Formatting Wizard.

Be sure to select the range to format prior to opening the CF Wizard and reference the TOP LEFT CELL of the range with your formula.

Beyond that, we would need more specific data.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[kc27]

OK, thanks much for the help. I was able to get it working.