
VIP

Trusted Members

December 7, 2016

Hello,
For more in deapth guidance on how to use Conditional Formatting, please check this blog post, it covers the most you should know.
As I don't know what version of Excel you have and the layout of your data, but in this example I assume you have Microsoft 365 (i.e. Office 365) and the dates starting from cell F5. Create a new Conditional Format rule and choose to use a formula to determine which cells to format, put in following formula:
=DAY(F5)=2
That will result in a TRUE if the date is the second of the month, any month and year, else it will result in a FALSE.
I hope you get back on track with this.
Br,
Anders

Active Member

September 19, 2020

Thank you Anders - I have used this formula but the conditional format does not work to pick these dates up. I have formatted the dates to date and not text, still no joy. Using MS 2016.
Appreciate your help with this - attached (possible senior moment....)
Kind regards,
Sherry
1 Guest(s)
