Conditional Formatting-Weekends & Public Holidays

H

howard

Well-known Member
Joined
Jun 26, 2006
Messages
6,563
Office Version
  1. 2021
Platform
  1. Windows
I have a workfile with Dates in column A. The Public Holidays have been set up in column B, but the public holiday dates are also in column A

I need conditional formatting the will highlight the weekend dates as well as the public holidays

I know how to set up conditional formatting to highlight weekends only, but not to incorporate Public Holidays as well. The formula below highlights weekends only. I need it amended so as to highlight public holidays as well.

Howard


=OR(WEEKDAY(A1)=7,WEEKDAY(A1)=1)
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Sort by date Sort by votes
Hi Jindon

Thanks for the help. Code working perfectly

Regards

Howard
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Calculating future date excluding Public Holiday, Weekends and Backdate specific date
Replies
1
Views
84
etaf
etaf
S
  • Solved
WORKDAY.INTL does not block out holidays
2
Replies
13
Views
547
shawnbull
S
E
  • Solved
How to use WORKDAY to calculate the Final Training Day and exclude Weekends and Public Holidays
Replies
5
Views
257
Fluff
Fluff
R
  • Solved
Subtracting all calendar days, but end date cannot fall on a weekend or holiday. If it does, the end date shifts to the preceding work day.
Replies
8
Views
248
Romy
R
B
  • Solved
How to exclude weekends & bank holidays
2
Replies
10
Views
489
KRice
K

Forum statistics

Threads
1,215,055
Messages
6,122,902
Members
449,097
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top