About Us

keithobro

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

"Biff" wrote:

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

Biff

"keithobro" wrote in message
...
Hi Biff

Thanks again for a swift reply.

Do you mean:

?

"Biff" wrote:

Send it to this address:

xl can help at comcast period net

Remove "can" and change the obvious.

Biff

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

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?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
conditional formatting with dates	Vabu3184	Excel Worksheet Functions	2	March 27th 06 02:11 AM
Conditional Formatting (Dates) Repost with additional data	BigH	Excel Discussion (Misc queries)	1	January 29th 06 10:18 PM
How do I create conditional formatting to track due dates	Soraiya	Excel Worksheet Functions	2	October 14th 05 03:26 PM
Conditional Formatting Dates	John	Excel Worksheet Functions	11	December 29th 04 08:43 PM
Conditional Formatting for dates	spacerocket	Excel Worksheet Functions	2	November 4th 04 10:13 AM

Menu

About Us