| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight on Date Problem
Hi everyone
I have the following in conditional format in column A =I54-TODAY()<=60 if true highlight Red This is working in most cases but for some reason when september dates are in the I column they also highlight red which is incorrect - am I missing something in the formula please? -- Thanks as always Lise |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight on Date Problem
Your formula is valid. An incorrect year will cause the problem stated. Are
you entering 2010, as opposed to 2009, or even 1910? Regards, Fred "Lise" wrote in message ... Hi everyone I have the following in conditional format in column A =I54-TODAY()<=60 if true highlight Red This is working in most cases but for some reason when september dates are in the I column they also highlight red which is incorrect - am I missing something in the formula please? -- Thanks as always Lise |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight on Date Problem
Hi Fred
Yes the year is correct 2010. Only happening on month of September - very annoying. -- Thanks as always Lise "Fred Smith" wrote: Your formula is valid. An incorrect year will cause the problem stated. Are you entering 2010, as opposed to 2009, or even 1910? Regards, Fred "Lise" wrote in message ... Hi everyone I have the following in conditional format in column A =I54-TODAY()<=60 if true highlight Red This is working in most cases but for some reason when september dates are in the I column they also highlight red which is incorrect - am I missing something in the formula please? -- Thanks as always Lise . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight on Date Problem
There's got to be something we're not seeing. When you format I54 to
General, what's the number that gets displayed? Fred "Lise" wrote in message ... Hi Fred Yes the year is correct 2010. Only happening on month of September - very annoying. -- Thanks as always Lise "Fred Smith" wrote: Your formula is valid. An incorrect year will cause the problem stated. Are you entering 2010, as opposed to 2009, or even 1910? Regards, Fred "Lise" wrote in message ... Hi everyone I have the following in conditional format in column A =I54-TODAY()<=60 if true highlight Red This is working in most cases but for some reason when september dates are in the I column they also highlight red which is incorrect - am I missing something in the formula please? -- Thanks as always Lise . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight a row with the current date. | Excel Worksheet Functions | |||
| Highlight expiry date | Setting up and Configuration of Excel | |||
| highlight problem | Excel Discussion (Misc queries) | |||
| Date Highlight | Excel Discussion (Misc queries) | |||
| highlight a date | Excel Discussion (Misc queries) | |||
Linear Mode
