Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with deadlines
I have a simple spreadsheet with due dates. Is there a way to make the due
dates turn green when they are 2 days out from current date (Today) ? I have office 2007. Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with deadlines
Yes.
Select the cells you want to highlight Click on Conditional Formatting on the HOME tab of the ribbon. Choose Highlight Cell Rules Choose a date occuring Choose the condition and the format you want or you may choose more rules and enter the condition you want "figvm" wrote: I have a simple spreadsheet with due dates. Is there a way to make the due dates turn green when they are 2 days out from current date (Today) ? I have office 2007. Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with deadlines
in the conditional formatting dialog, choose the option "Formula" in the
dropdown and enter =A2-NOW()<2 which obviously applies to cell A2 only.... Note that you can use the format painter to copy this to other cells. "figvm" wrote: I have a simple spreadsheet with due dates. Is there a way to make the due dates turn green when they are 2 days out from current date (Today) ? I have office 2007. Thank you! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with deadlines
in the conditional formatting dialog, choose the option "Formula" in the
dropdown and enter =A2-NOW()<4 which obviously applies to cell A2 only.... Note that you can use the format painter to copy this to other cells. "figvm" wrote: I have a simple spreadsheet with due dates. Is there a way to make the due dates turn green when they are 2 days out from current date (Today) ? I have office 2007. Thank you! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with deadlines
Hi,
To answer the specific question you asked 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =TODAY()-2=A1 5. Click the Format button and choose a format. 6. Click OK twice If you want to do it for the two days before today then: =OR(TODAY()-A1=2,TODAY()-A1=1) Or if you want to format all date which are on or after Today-2 then =A1=TODAY()-2 would do. -- If this helps, please click the Yes button Cheers, Shane Devenshire "figvm" wrote: I have a simple spreadsheet with due dates. Is there a way to make the due dates turn green when they are 2 days out from current date (Today) ? I have office 2007. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
conditional formatting deadlines | Excel Discussion (Misc queries) |