jasmine1234
New Member
- Joined
- Aug 14, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
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
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