| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Today's Due Date in Colour
Please help.
I have a column called "Due Date" I will like every morning, to have all the dates that are due the current day (()Today) to be highlited in red. Can this be done, if so how? Thanks. /keith |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Today's Due Date in Colour
Hi Keith
You can use CF http://www.contextures.com/xlCondFormat01.html -- Regards Ron de Bruin http://www.rondebruin.nl "Keith Camacho" wrote in message ink.net... Please help. I have a column called "Due Date" I will like every morning, to have all the dates that are due the current day (()Today) to be highlited in red. Can this be done, if so how? Thanks. /keith |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Today's Due Date in Colour
Keith, if your column is A then select it and format, conditional formatting
Formula is =A1=TODAY() and set the Patten to red -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Keith Camacho" wrote in message ink.net... Please help. I have a column called "Due Date" I will like every morning, to have all the dates that are due the current day (()Today) to be highlited in red. Can this be done, if so how? Thanks. /keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum a range if the date is is greater than today's date? | Excel Worksheet Functions | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Launch excel showing today's date | Excel Discussion (Misc queries) | |||
| Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
| Activating "Todays Date" column upon opening? | Excel Discussion (Misc queries) | |||
Linear Mode
