If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Highlight date nearest to TODAY()
Hi I have dates in a column in this format : 16/01/2010 16/02/2010 16/03/2010 16/04/2010 16/05/2010 16/06/2010 I'm trying to set the conditional formatting so that the nearest date to today is in bold. Can someone help with this? Grateful for any advice. Best Wishes |
#2
|
|||
|
|||
Highlight date nearest to TODAY()
Define nearest.
If these were your dates: 15/3/2010 17/3/2010 And today was 16/3/2010 Which is the nearest date? -- Biff Microsoft Excel MVP "Colin Hayes" wrote in message ... Hi I have dates in a column in this format : 16/01/2010 16/02/2010 16/03/2010 16/04/2010 16/05/2010 16/06/2010 I'm trying to set the conditional formatting so that the nearest date to today is in bold. Can someone help with this? Grateful for any advice. Best Wishes |
#3
|
|||
|
|||
Highlight date nearest to TODAY()
In article , T. Valko
writes Define nearest. If these were your dates: 15/3/2010 17/3/2010 And today was 16/3/2010 Which is the nearest date? HI Thanks for getting back. All the dates are a month apart in my example. So I guess could Today () versus the given date could be set to plus or minus 16. That would probably do the trick , but I can't think my way through the formula to enter into the conditional formatting interface. Thanks for your help. |
#4
|
|||
|
|||
Highlight date nearest to TODAY()
Assuming your data is sort in ascending order
Conditional Formatting: =$A1=INDEX($A$1:$A$6,MATCH(TODAY(),$A$1:$A$6)) "Colin Hayes" wrote: Hi I have dates in a column in this format : 16/01/2010 16/02/2010 16/03/2010 16/04/2010 16/05/2010 16/06/2010 I'm trying to set the conditional formatting so that the nearest date to today is in bold. Can someone help with this? Grateful for any advice. Best Wishes . |
#5
|
|||
|
|||
Highlight date nearest to TODAY()
OK, but you didn't answer my question.
If these were your dates: 15/3/2010 17/3/2010 And today was 16/3/2010 Which is the nearest date? Both of the dates are an equal difference from the target date. So which is the nearest date? -- Biff Microsoft Excel MVP "Colin Hayes" wrote in message ... In article , T. Valko writes Define nearest. If these were your dates: 15/3/2010 17/3/2010 And today was 16/3/2010 Which is the nearest date? HI Thanks for getting back. All the dates are a month apart in my example. So I guess could Today () versus the given date could be set to plus or minus 16. That would probably do the trick , but I can't think my way through the formula to enter into the conditional formatting interface. Thanks for your help. |
#6
|
|||
|
|||
Highlight date nearest to TODAY()
See attached. Not much for real formulas were needed. Used Conditional
formatting in Excel 2007. A1 has "=Today()" Then I used Conditional formatting Highlight Cells Rules Between... "Colin Hayes" wrote in message ... Hi I have dates in a column in this format : 16/01/2010 16/02/2010 16/03/2010 16/04/2010 16/05/2010 16/06/2010 I'm trying to set the conditional formatting so that the nearest date to today is in bold. Can someone help with this? Grateful for any advice. Best Wishes |
Thread Tools | |
Display Modes | |
|
|