Conditional formatting dates based on date range and day

Hi,

I have a file I use to track projects, where there is conditional formatting in place to colour a bar of dates to show when projects run from/to. This is the general 'cell value between' formatting. As project days are not always Mon-Sun, I want to include a criteria so that only the days stated are coloured. So if a project runs for the whole month of November, but only Mon-Wed, then only the days of Mon-Wed during November are coloured.

Attached is a sample file.

Book2.xlsx

The days in col A and B are the days from - to. So everthing between and including cell A and cell B are to be coloured.

The days are reference from another tab, which has to have the days manually written in, and both are formatted as 'general'. I'm wondering if these need to be re-worked/re-formatted to something different to be able to compare correctly...


Thank you in advance for any time/help

DBY that's great - your example is exactly what I'm after!

However... having tried to apply it onto my own file, I can't get it to work... I've attached another file showing exactly where my data sits on the tab (and have amended my own file to match yours, where the date sits in the grey row of cells, rather than in each cell as I had before). I'm wondering if having merged cells is creating a problem, or whether I'm doing something wrong.

Copy of Book3.xlsx

EDIT: Scrap that - just realised your 'Days' is a named range. I've added this in and now it workes perfectly! Thank you again for your help.

You have already marked it as solved, so its less likely to be visible to others. Its better you open up a new thread and link back to this thread.