Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula to change color of a cell when date is over a year old?
I'm looking for a formula to change dates that I have in a row once they are
over a year old. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula to change color of a cell when date is over a year old?
hi
FORMAT | CONDITIONAL FORMAT hth regards from Brazil Marcelo "jvmn" escreveu: I'm looking for a formula to change dates that I have in a row once they are over a year old. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula to change color of a cell when date is over a year old?
jvmn, Your title says to change the color once over a year but the post says to change the date? To change the color use Conditional Formatting. FormatConditional Formating Change Cell Value Is option to Formula is. Use this in A1 (or where your dates begin). =DATEDIF(A1,TODAY(),"y")0 Click on Format, Patterns and choose a color. Click OK and OK. You can then copy this format to the rest of your range using either Past Special - Formats or using the Format Painter. I believe that you'll need to install the Analysis ToolPak to use this formula. To do so go to ToolsAdd-ins and check off the analysis toolpak option. Click ok. Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=555993 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
holiday dates | Excel Worksheet Functions | |||
Change Year Date In A Formula Throughout The Spreadsheet | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Need to use IF formula with a Date cell | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |