Using conditional formatting to plot campaign dates.

[keithobro]

I'm running a spreadsheet to show recruitment campaigns at stores. I have
'start date' in one colum, 'end date' in next column. I have dates of month
in following columns. I've tried a formula in conditional formatting to turn
the relevant dates in a campaign 'shaded', if they fall within the start and
end dates. But the formatting fails on the final day of a campaign, unless it
happens to be the last day of the month. Here's the formula I'm using:

=IF(LEN(F$6)>0,AND(E$6>=$C7,F$6<=$D7),E$6<=$D7)

Can anyone help adjust this so that the final date of the campaign always
becomes "shaded", please?

 

[Biff]

Hi!

Try this:

C7 = start date
D7 = end date
E6:AI6 = dates of the month

Select the range E6:AI6
Conditional Formatting
Formula Is:

=AND(COUNT($C$7,$D$7)=2,E$6>=$C$7,E$6<=$D$7)

Biff

 

[keithobro]

Hi Biff.

I tried it, but it didn't work. I tried e-mailing you direct with the
spreadsheet, but it came back undeliverable. Any other ideas please?

 

[Biff]

Send it to this address:

xl can help at comcast period net

Remove "can" and change the obvious.

Biff

 

[keithobro]

Hi Biff

Thanks again for a swift reply.

Do you mean:

(e-mail address removed) ?

 

[Biff]

Yeah, but thanks for exposing my email address! Can I redirect the spam to
you?

Biff

 

[keithobro]

I'm sorry. I wasn't aware I'd done so. New to all this stuff.