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. |
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. |
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 |
All times are GMT +1. The time now is 10:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com