Excel Help Pleeeeeeease

Bella79

Figured it out. Thank you

Boom_Shakalaka

Hi there I'm new to the forum and just stumbled across this thread, I know a bit about excel so will help if I can.

I'm hoping that the names and dates are in two separate colums, we'll say A & B starting from A3, A's containing names and B's containing dates and the A1 cell having todays date.

B3 would have the formula =B3+84 (this gives a new date 12 weeks ahead)

Then it is simply a case of conditional formating the C column with:

cell value =$A$1+14 (assign colours for the two week prior to todays date)
&
cell value less than or equal to =$A$1(assign different colours)

that should do it and if you test it out and change "todays date" to a date within 2 weeks of the new date and to a date after that date it should work.

Hope that makes sense.
Dan

wealdroam

Isn't it a pity that the OP has deleted the original post thus making Boom Shakalaka's reply virtually meaningless.

Very selfish Bella... shame on you.

Anyway, for those interested, here is the original post...

Bella79 wrote: »

Hi all

Ive got a huge database full of names and dates eg:

Blogs j 01-mar-2012


What i want to do is when i put the date in it automaticly creates a new date in the next coloum 12 weeks from the exsiting date.

Then in the new 12 week date coloum the new date to turn one colour when its at 10 week then another colour when it is at the date or over, I have tried conditional formula and i can get it to turn one colour at 70 days (10wk) but the second condition for 84 days will not work?

Also can i make it so that this applys to the entire coloums even those that are not yet populated wtih information.

Thank You

Boom Shakalaka, welcome to the forums.
Please be assured that we are not all as rude.

debitcardmayhem

wealdroam wrote: »

Isn't it a pity that the OP has deleted the original post thus making Boom Shakalaka's reply virtually meaningless.

Very selfish Bella... shame on you.

Anyway, for those interested, here is the original post...

Boom Shakalaka, welcome to the forums.
Please be assured that we are not all as rude.

I am surprised that the OP didn't post "bump" after 10 minutes :rotfl::rotfl: