Conditional Formatting - Based on date ranges

Hi again,

Since getting the help yesterday to complete my biggest challenge to date with my excel, I figured I'd be able to understand conditional formatting. I've done some simple conditional formatting in the past but what I'm hoping to achieve here hurts my brain to think about.

Attached is my file from yesterday with the formulae you guys helped me with, now what I'm looking to do is set up a colour scheme to match our projected start and end dates. I've seen a few examples on this forum but they went through a single reference point and I'm hoping to use the start and end dates to colour sections of a 6 month schedule based on dates entered in only one row then projected down.

Reading that back is slightly confusing to me, so any help is appreciated and happy to clarify anything I can. I've written on the spreadsheet in boxes to try to clarify.

Here's a coupld of different ways:

First, select the cells from F5 to EZ7, then click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the dialogue box:

=AND(F$3>=$D5,F$3<=$E5)

Click on the Format button | Fill tab and choose your colour, then click OK twice to exit the dialogue box - Excel will automatically adjust the ranges in that formula to suite the selected cells.

Another way is to fill the cells with a character and then the CF is condition is set if a cell contains that character. For example, put this formula into cell F3:

=IF(AND(F$3>=$D5,F$3<=$E5),"x","")

Then copy across and down to suit your display - this will show x on each day between the date range(s). Then your CF condition is simply Cell Contains "x" - ensure that both the foreground and background colour is set to the same, so that the x is not visible.

Hope this helps.

Pete

That's perfect, thanks a lot Pete

You're welcome - glad to be able to help.

Thanks for the rep.

Pete