Date
 

Hi
I have entered a date in a cell. I would like the next cell to take the date automatically +3 days from the pervious cell and the colour should change after the actual date is equal to +3days.

Date
 

If the Date is entered into A1
Enter the formula
=A1+3 into the next cell and copy / paste down or across as required.
Use Format-Conditional Formatting to control the cell background colours
based on the condition(s) required.

Cheers
Nigel

"Sanjeev" wrote in message
...
Hi,
I have entered a date in a cell. I would like the next cell to take the
date automatically +3 days from the pervious cell and the colour should
change after the actual date is equal to +3days.

Date
 

The conditional format could have a condition of Formula Is and a formula of
=B1<=TODAY()
assuming that you use B1 to enter Nigel's Formula

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Nigel" wrote in message
...
If the Date is entered into A1
Enter the formula
=A1+3 into the next cell and copy / paste down or across as required.
Use Format-Conditional Formatting to control the cell background colours
based on the condition(s) required.

Cheers
Nigel

"Sanjeev" wrote in message
...
Hi,
I have entered a date in a cell. I would like the next cell to take the
date automatically +3 days from the pervious cell and the colour should
change after the actual date is equal to +3days.

Date
 

How do i Make the content in a cell blink.

Date
 

Hi
not possible with build-functionality (and I'm vera glad there's no
such feature).
You could achieve this with a OnTime method constantly running and
changing the cell color (search the Google archive for 'blinking cell')

But PLEASE don't use such a feature in a serious spreadsheet!


--
Regards
Frank Kabel
Frankfurt, Germany


Sanjeev wrote:
How do i Make the content in a cell blink.