Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi, this problem should be easy, but I can't get it to work
Colum A10 as a date, with the month and year for the next two years listed. I have the current datein A1, using today() forumla. What I would like to do is highlight the row starting from A10 with as the current date in it. Tried conditonal formatting as follows Selected the rows I want to be highlighted with the date.That would be say A10 through to A60. Selected Conditional formatting, then formula is Then entered say =$A1=today() But this does not work. Where am I going wrong, can someone help me please. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
highlight current date | Excel Discussion (Misc queries) | |||
highlight current row/column | Excel Discussion (Misc queries) | |||
calendar highlight current date | Excel Discussion (Misc queries) | |||
how do I highlight the current row and column | Excel Discussion (Misc queries) | |||
how to highlight current row & column automatically by a color | Excel Discussion (Misc queries) |