VEhicle Maintenance

C

Cass

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?
 
M

Mike H

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<>"",A1>TODAY()-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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vehicle Maintenance Workbook 1
Access Parking violations Access Database 0
Code/Function to Look at Previous Entry to Validate Data 6
Hyperlink worksheet data to a index in a workbook? 1
Earliest/Latest Date Query 10
Boiler Cover Recommendations 6
Is there a Mileage Tracking function? 1
COUNT IF but not if 'X' IS NULL 5

Top