bobtheboffin
New Member
- Joined
- Nov 25, 2016
- Messages
- 1
Hi all,
I've got a list of dates (throughout the year) which should be the last date of their respective month (31st, 30th, 28th/29th for Feb). There are, however a number of dates which aren't the last day of a month e.g. 3rd, 11th, 21st etc. and I want to be able to Conditionally Format the list to highlight these in red, I also want to be able to count how many dates are not the last day of the month.
Is it possible to do either of these things?
Many thanks for your help.
I've got a list of dates (throughout the year) which should be the last date of their respective month (31st, 30th, 28th/29th for Feb). There are, however a number of dates which aren't the last day of a month e.g. 3rd, 11th, 21st etc. and I want to be able to Conditionally Format the list to highlight these in red, I also want to be able to count how many dates are not the last day of the month.
Is it possible to do either of these things?
Many thanks for your help.