VEhicle Maintenance
I know the date that a vehicle needs to go in for it's yearly maintenance and
i want to see if i can cause the cell that the date is in to change color a month prior to the date....does anyone know if that can be done and how to do that? |
VEhicle Maintenance
Hi,
I'm guessing that this applies to a column of cells so select that column range then Format|Conditional format Select formula is enter this formula =AND(A1<"",A1TODAY()-30) pick a colour Note that the A1 should be the address of the topmost cell of your range which in your case may not be A1 Mike "Cass" wrote: I know the date that a vehicle needs to go in for it's yearly maintenance and i want to see if i can cause the cell that the date is in to change color a month prior to the date....does anyone know if that can be done and how to do that? |
All times are GMT +1. The time now is 10:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com