|
Conditional Formatting (Dates)
I can't wrap my head around this conditional formatting stuff.
Is it possible to do the following? My F3 cell contains a date. If F3 is greater than or equal to 1 year, I want my A3 cell to be colored yellow. Any help would be greatly appreciated. |
Hi!
If F3 contains a date greater than 12/31/1900, then it's going to be greater than or equal to 1 year. I think a better explanation is needed! Biff "d_birr77" wrote in message ... I can't wrap my head around this conditional formatting stuff. Is it possible to do the following? My F3 cell contains a date. If F3 is greater than or equal to 1 year, I want my A3 cell to be colored yellow. Any help would be greatly appreciated. |
Oops !!
I have a date entered in F3 (example: 2003/01/20). If from today's date, F3 is more than one year, then I want A1 to be colored yellow. EX1: Today's date is 2005/07/18 - the date entered in F3 is 2005/06/07 - (less than one year) - I don't want A1 colored yellow. EX2: Today's date is 2005/07/18 - the date entered in F3 is 2004/06/07 - (more than one year) - I do want A1 colored yellow. I hope this clarifies. Thanks in advance. "Biff" wrote: Hi! If F3 contains a date greater than 12/31/1900, then it's going to be greater than or equal to 1 year. I think a better explanation is needed! Biff "d_birr77" wrote in message ... I can't wrap my head around this conditional formatting stuff. Is it possible to do the following? My F3 cell contains a date. If F3 is greater than or equal to 1 year, I want my A3 cell to be colored yellow. Any help would be greatly appreciated. |
OK....
Select cell A1 Goto FormatConditional Formatting Formula is: =TODAY()-365$F$3 Click the Format button and select the style you'd like OK out Since leap years have 366 days, do you want to account for that or will the "standard" year suffice? Biff "d_birr77" wrote in message ... Oops !! I have a date entered in F3 (example: 2003/01/20). If from today's date, F3 is more than one year, then I want A1 to be colored yellow. EX1: Today's date is 2005/07/18 - the date entered in F3 is 2005/06/07 - (less than one year) - I don't want A1 colored yellow. EX2: Today's date is 2005/07/18 - the date entered in F3 is 2004/06/07 - (more than one year) - I do want A1 colored yellow. I hope this clarifies. Thanks in advance. "Biff" wrote: Hi! If F3 contains a date greater than 12/31/1900, then it's going to be greater than or equal to 1 year. I think a better explanation is needed! Biff "d_birr77" wrote in message ... I can't wrap my head around this conditional formatting stuff. Is it possible to do the following? My F3 cell contains a date. If F3 is greater than or equal to 1 year, I want my A3 cell to be colored yellow. Any help would be greatly appreciated. |
What change needs to be made to account for leap years?
"Biff" wrote: OK.... Select cell A1 Goto FormatConditional Formatting Formula is: =TODAY()-365$F$3 Click the Format button and select the style you'd like OK out Since leap years have 366 days, do you want to account for that or will the "standard" year suffice? Biff "d_birr77" wrote in message ... Oops !! I have a date entered in F3 (example: 2003/01/20). If from today's date, F3 is more than one year, then I want A1 to be colored yellow. EX1: Today's date is 2005/07/18 - the date entered in F3 is 2005/06/07 - (less than one year) - I don't want A1 colored yellow. EX2: Today's date is 2005/07/18 - the date entered in F3 is 2004/06/07 - (more than one year) - I do want A1 colored yellow. I hope this clarifies. Thanks in advance. "Biff" wrote: Hi! If F3 contains a date greater than 12/31/1900, then it's going to be greater than or equal to 1 year. I think a better explanation is needed! Biff "d_birr77" wrote in message ... I can't wrap my head around this conditional formatting stuff. Is it possible to do the following? My F3 cell contains a date. If F3 is greater than or equal to 1 year, I want my A3 cell to be colored yellow. Any help would be greatly appreciated. |
After thinking about it, it may be more overly complicated then I first
thought and in the end may be a useless endeavor. Seems to me it would only appy if TODAY() is Feb 29 or after of a leap year in which case you'd subtract 366 days. That's the problem we sometimes run into working with dates. How many days are in a year? How many days are in a month? Week numbers are a nightmare! Biff "d_birr77" wrote in message ... What change needs to be made to account for leap years? "Biff" wrote: OK.... Select cell A1 Goto FormatConditional Formatting Formula is: =TODAY()-365$F$3 Click the Format button and select the style you'd like OK out Since leap years have 366 days, do you want to account for that or will the "standard" year suffice? Biff "d_birr77" wrote in message ... Oops !! I have a date entered in F3 (example: 2003/01/20). If from today's date, F3 is more than one year, then I want A1 to be colored yellow. EX1: Today's date is 2005/07/18 - the date entered in F3 is 2005/06/07 - (less than one year) - I don't want A1 colored yellow. EX2: Today's date is 2005/07/18 - the date entered in F3 is 2004/06/07 - (more than one year) - I do want A1 colored yellow. I hope this clarifies. Thanks in advance. "Biff" wrote: Hi! If F3 contains a date greater than 12/31/1900, then it's going to be greater than or equal to 1 year. I think a better explanation is needed! Biff "d_birr77" wrote in message ... I can't wrap my head around this conditional formatting stuff. Is it possible to do the following? My F3 cell contains a date. If F3 is greater than or equal to 1 year, I want my A3 cell to be colored yellow. Any help would be greatly appreciated. |
No worries. I got the spreadsheet working the way I wanted it to.
I want to thank you for your help. "Biff" wrote: After thinking about it, it may be more overly complicated then I first thought and in the end may be a useless endeavor. Seems to me it would only appy if TODAY() is Feb 29 or after of a leap year in which case you'd subtract 366 days. That's the problem we sometimes run into working with dates. How many days are in a year? How many days are in a month? Week numbers are a nightmare! Biff "d_birr77" wrote in message ... What change needs to be made to account for leap years? "Biff" wrote: OK.... Select cell A1 Goto FormatConditional Formatting Formula is: =TODAY()-365$F$3 Click the Format button and select the style you'd like OK out Since leap years have 366 days, do you want to account for that or will the "standard" year suffice? Biff "d_birr77" wrote in message ... Oops !! I have a date entered in F3 (example: 2003/01/20). If from today's date, F3 is more than one year, then I want A1 to be colored yellow. EX1: Today's date is 2005/07/18 - the date entered in F3 is 2005/06/07 - (less than one year) - I don't want A1 colored yellow. EX2: Today's date is 2005/07/18 - the date entered in F3 is 2004/06/07 - (more than one year) - I do want A1 colored yellow. I hope this clarifies. Thanks in advance. "Biff" wrote: Hi! If F3 contains a date greater than 12/31/1900, then it's going to be greater than or equal to 1 year. I think a better explanation is needed! Biff "d_birr77" wrote in message ... I can't wrap my head around this conditional formatting stuff. Is it possible to do the following? My F3 cell contains a date. If F3 is greater than or equal to 1 year, I want my A3 cell to be colored yellow. Any help would be greatly appreciated. |
| All times are GMT +1. The time now is 08:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com