Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format (Todays Date)
In column A, starting in row 5 I have dates, May 15, 2008 through to Sept 15,
2008. I am using a Conditional Format to highlight todays date =$A5=TODAY(). It is working great on one worksheet. I have made a another similar sheet, and am trying to do the same thing. The dates on the second sheet start in A3. I am using the same conditional format, but changing it to A3. =$A3=TODAY() The first one works fine, but the second one highlights the last cell, A110 Sept 15, 2008. Can someone please shed some light on this for me? Thanks Kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format (Todays Date)
I got it to work, I copy and pasted it onto a new worksheet and it worked.
Weird! "Kevin" wrote: In column A, starting in row 5 I have dates, May 15, 2008 through to Sept 15, 2008. I am using a Conditional Format to highlight todays date =$A5=TODAY(). It is working great on one worksheet. I have made a another similar sheet, and am trying to do the same thing. The dates on the second sheet start in A3. I am using the same conditional format, but changing it to A3. =$A3=TODAY() The first one works fine, but the second one highlights the last cell, A110 Sept 15, 2008. Can someone please shed some light on this for me? Thanks Kevin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format (Todays Date)
Hi Kevin,
I think that you have a problem in the way you are setting conditional format. In pre xl2007 versions do the following:- Select all the cells to have the conditional format. Select Format-Conditional format Under Condition1 select "Cell value is" Next field click drop down and select "equal to" Next field enter =TODAY() Click format button and set required format Click OK In xl2007 Select all the cells to have the conditional format. On Home ribbon select Conditional formatting Select New rule Under rule type Select format only cells that contain "Cell value is" (Default) Next field click drop down and select "equal to" Next field enter =TODAY() Click format button and set required format Click OK -- Regards, OssieMac "Kevin" wrote: In column A, starting in row 5 I have dates, May 15, 2008 through to Sept 15, 2008. I am using a Conditional Format to highlight todays date =$A5=TODAY(). It is working great on one worksheet. I have made a another similar sheet, and am trying to do the same thing. The dates on the second sheet start in A3. I am using the same conditional format, but changing it to A3. =$A3=TODAY() The first one works fine, but the second one highlights the last cell, A110 Sept 15, 2008. Can someone please shed some light on this for me? Thanks Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
todays date | Excel Discussion (Misc queries) | |||
Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
Todays date | Excel Discussion (Misc queries) | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions |