Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
I'd like to conditionally format a cell based on today's date
I have a column that contains important dates, and I'd like to say make the
forecolor red if they're 3 months away, blue if their 6 months away, etc... How do I do this? |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
I'd like to conditionally format a cell based on today's date
Look up "conditional formatting" in Excel help.
-- David Biddulph "0to60" wrote in message ... I have a column that contains important dates, and I'd like to say make the forecolor red if they're 3 months away, blue if their 6 months away, etc... How do I do this? |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
I'd like to conditionally format a cell based on today's date
On Aug 20, 2:32*pm, "0to60" wrote:
I have a column that contains important dates, and I'd like to say make the forecolor red if they're 3 months away, blue if their 6 months away, etc.... How do I do this? This will set it up for you: Sub SetUpConditions() Range("B2").Select With Range("B2") .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:= _ "=$B$2=INT(NOW())+180" .FormatConditions(1).Font.ColorIndex = 2 .FormatConditions(1).Interior.ColorIndex = 5 .FormatConditions.Add Type:=xlExpression, Formula1:= _ "=$B$2=INT(NOW())+90" .FormatConditions(2).Font.ColorIndex = 2 .FormatConditions(2).Interior.ColorIndex = 3 End With End Sub Then have a look at Format - Conditonal Formatting to tweak it. Hope this helps. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I conditionally format a cell based on the value in a diff | Excel Discussion (Misc queries) | |||
Conditional Formatting based on Today's Date | Excel Discussion (Misc queries) | |||
multiple If's based on today's date | Excel Worksheet Functions | |||
Can I conditionally format a line based on a cell value | Excel Discussion (Misc queries) | |||
how do you conditional format based upon today's date? | Excel Worksheet Functions |