Using conditional formatting to plot campaign dates.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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?
 
Send it to this address:

xl can help at comcast period net

Remove "can" and change the obvious.

Biff
 
Back
Top