conditional formatting

biglb79

Board Regular
Joined
Oct 17, 2007
Messages
223
Is it possible to setup a rule that can highlight a date in column H red if the date does not fall on a Monday or the 10th of each month?
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,684
Office Version
365
Platform
Windows
How about
=AND(DAY(H2)<>10,TEXT(H2,"ddd")<>"mon")
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,684
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,099,097
Messages
5,466,636
Members
406,493
Latest member
Hazem Hassan

This Week's Hot Topics

Top