Conditional formatting for final date of month for given date data

[jasmine1234]

Hi,

I have a large amount of data ranging from 2022 through to 2007 with almost every day of the year, however some data is missing (dates are in the format of dd/mm/yyyy). I need to highlight the final day of each month for this given data. Can someone please assist with determining the formula for this as going through every cell is not an option. If this is possible using conditional formatting that would be amazing.

Thanks for your help
Jasmine

 

[bebo021999]

Quick answer need visual help. pls attach a screenshot/XL2BB mini sheet

 

[jasmine1234]

 

[bebo021999]

An image with wide range data does not help much. Do not let the helpers have to input data manually.
Try XL2BB

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com