How to highlight the most recent date in Excel?


If you have much date that you difficult to find it that is the recent date or the last date.So this way we need to high light the date that make you can find it very fast as soon as possible and easy for processing the work .
Here is how to do that:
1. Go to Condition Formatting and Choose New rule
2. Then Click Format only cells that contain
3. Format only Cells with (cell Value+ equal to+ (=Max(cell))
Picture below for detail.



Sample Example Download Here

Comments