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 |
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 |
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 |
All times are GMT +1. The time now is 02:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com