| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change color if more than a year old
Hi All, what is the easiest way to accomplish this? Basically if a date is
more than a year old, i want it bolded and red. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change color if more than a year old
Assuming the cell(s) actually have a date in them and not plain text, use
Conditional Formatting. Select the cells then Format--Conditional Formating... use the 'Cell Value Is' option along with "less than" and enter Now()-365 into the 3rd entry area. Click [Format...] and set the font properties to Bold and Red. "Steph" wrote: Hi All, what is the easiest way to accomplish this? Basically if a date is more than a year old, i want it bolded and red. Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change color if more than a year old
You rock, thanks!!!
"JLatham" wrote: Assuming the cell(s) actually have a date in them and not plain text, use Conditional Formatting. Select the cells then Format--Conditional Formating... use the 'Cell Value Is' option along with "less than" and enter Now()-365 into the 3rd entry area. Click [Format...] and set the font properties to Bold and Red. "Steph" wrote: Hi All, what is the easiest way to accomplish this? Basically if a date is more than a year old, i want it bolded and red. Thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change color if more than a year old
That can be done in conditional formatting, use this formula but adjust the cell address =$A$1<TODAY()-365 Steph;643837 Wrote: Hi All, what is the easiest way to accomplish this? Basically if a date is more than a year old, i want it bolded and red. Thanks! -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=179376 Microsoft Office Help |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change color if more than a year old
Oddly, the formula I came up with didn't work! I had to change the formula to:
DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-365 to get it to act properly in the conditional formatting. "Steph" wrote: Hi All, what is the easiest way to accomplish this? Basically if a date is more than a year old, i want it bolded and red. Thanks! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change color if more than a year old
actually, now that I checked it, it's not working for me either way! It
stays red and bold regardless of date. Thanks for any help. "JLatham" wrote: Oddly, the formula I came up with didn't work! I had to change the formula to: DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-365 to get it to act properly in the conditional formatting. "Steph" wrote: Hi All, what is the easiest way to accomplish this? Basically if a date is more than a year old, i want it bolded and red. Thanks! |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change color if more than a year old
Another one
In A1 enter =TODAY()-365 For the CF Cell value is, less than, =$A$1 or Name a formula Name: LastYear Refersto: =TODAY()-365 (go back make sure quotes didn't get included) Cell value is, less than, =LastYear Regards, Peter T "Steph" wrote in message ... Hi All, what is the easiest way to accomplish this? Basically if a date is more than a year old, i want it bolded and red. Thanks! |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change color if more than a year old
awesome, thank you all!
"Simon Lloyd" wrote: That can be done in conditional formatting, use this formula but adjust the cell address =$A$1<TODAY()-365 Steph;643837 Wrote: Hi All, what is the easiest way to accomplish this? Basically if a date is more than a year old, i want it bolded and red. Thanks! -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=179376 Microsoft Office Help . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Year-over-year percentage of change | Excel Worksheet Functions | |||
| need formula 4 %change on both neg and pos movemnt year to year co | Excel Discussion (Misc queries) | |||
| change the year in a calendar template to different year | Excel Discussion (Misc queries) | |||
| formula to change color of a cell when date is over a year old? | New Users to Excel | |||
| Browse Forms Controls and change TextBox color based on cell color | Excel Programming | |||
![Steph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
