|
| 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
March 17th, 2010, 01:40 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
March 17th, 2010, 02:06 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
March 17th, 2010, 02:19 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
March 17th, 2010, 02:39 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
March 17th, 2010, 03:03 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
March 17th, 2010, 03:51 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
