Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date
How do i Make the content in a cell blink.
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |