Bank Holidays - conditional formatting and 'blanking'

Hi all,

Can I just say thanks to all the contributors on here, great great help. Is there a way I can donate?

Right, so I've nearly get there but I'm just having trouble with bank holidays on my scheduler (attached). Basically, all I need to do now is:

a) If a 'Work Date' is a bank holiday, for example 01/01/15, I'd like it to conditionally format in the same way as weekend dates are conditionally formatted.

b) If a 'Work Date' is a bank holiday, I'd like the corresponding 'Deadline' to go blank in the same way as it does when the 'Work Date' is a weekend.

Please can you help? I've tried the obvious COUNTIF solution on both but have had no joy.

On further reflection, I believe your bank holiday list can be left intact with the use of COUNTIF as you suggested. If you prefer to go that route let me know and I can make an update.

Thanks, that's great :D