Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with Today() Function.
I have a list of dates starting from A2 to A367 and I would like to
Highlight the current date. I can do it by placing the function "DATE() " in a cell and reference that cell but I can't do it in Conditional Formatting using "Formula is " with a Function. Is it possible or I need to have a date in a cell to refer to. Regards John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with Today() Function.
You are on the right track using Conditional Formatting.
Highight your column of dates Condition: Cell value is equal to =TODAY() Select the formatting you desire to apply. "John" wrote: I have a list of dates starting from A2 to A367 and I would like to Highlight the current date. I can do it by placing the function "DATE() " in a cell and reference that cell but I can't do it in Conditional Formatting using "Formula is " with a Function. Is it possible or I need to have a date in a cell to refer to. Regards John |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with Today() Function.
Select A2:A367
Format|conditional formatting| Cell Value is Equal to: =today() and give it a nice format ==== ps. =today() returns today's date. =date(2008,8,31) would return August 31, 2008. John wrote: I have a list of dates starting from A2 to A367 and I would like to Highlight the current date. I can do it by placing the function "DATE() " in a cell and reference that cell but I can't do it in Conditional Formatting using "Formula is " with a Function. Is it possible or I need to have a date in a cell to refer to. Regards John -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with Today() Function.
Select A2:A367
FormatCFFormula is: =A2=TODAY() Choose a color and OK your way out. Gord Dibben MS Excel MVP On Tue, 26 Aug 2008 10:30:08 -0400, "John" wrote: I have a list of dates starting from A2 to A367 and I would like to Highlight the current date. I can do it by placing the function "DATE() " in a cell and reference that cell but I can't do it in Conditional Formatting using "Formula is " with a Function. Is it possible or I need to have a date in a cell to refer to. Regards John |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with Today() Function.
Thank you Elisabeth
Its working fine. "Elisabeth D" wrote in message ... You are on the right track using Conditional Formatting. Highight your column of dates Condition: Cell value is equal to =TODAY() Select the formatting you desire to apply. "John" wrote: I have a list of dates starting from A2 to A367 and I would like to Highlight the current date. I can do it by placing the function "DATE() " in a cell and reference that cell but I can't do it in Conditional Formatting using "Formula is " with a Function. Is it possible or I need to have a date in a cell to refer to. Regards John |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with Today() Function.
Thank you All for your reply
I got it working thanks to you all. Regards John "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Select A2:A367 FormatCFFormula is: =A2=TODAY() Choose a color and OK your way out. Gord Dibben MS Excel MVP On Tue, 26 Aug 2008 10:30:08 -0400, "John" wrote: I have a list of dates starting from A2 to A367 and I would like to Highlight the current date. I can do it by placing the function "DATE() " in a cell and reference that cell but I can't do it in Conditional Formatting using "Formula is " with a Function. Is it possible or I need to have a date in a cell to refer to. Regards John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting on date where today is or = datevalue | Excel Discussion (Misc queries) | |||
Conditional Formatting on 'Today' | Setting up and Configuration of Excel | |||
Conditional Formatting with IF function | Excel Worksheet Functions | |||
Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
Conditional Formatting ... Today() & More | Excel Worksheet Functions |