Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vehicle check list templet | Excel Discussion (Misc queries) | |||
Vehicle Maintenance Workbook | Excel Worksheet Functions | |||
Vehicle Maintenance Workbook | Excel Worksheet Functions | |||
vehicle fleet maintenance | Excel Worksheet Functions | |||
help in creating charts of vehicle data | Charts and Charting in Excel |