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" wrote in message
...
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?