maybe a Macro?

C

Cindy Conover

I have use Excel in a very limited capacity for years so I am going to try
to explain what I want the best I can. I have a spreadsheet that I created
to keep track of the services and inspections of company vehicles. This
works great but every week I have to go through each unit to high light the
units that need attention. The spreadsheet looks like the following:

Unit (B1), Last Pm Date (D1), Last PM Miles (E1), Last DOT Date (F1),Current
Miles (G1), Next Pm Date (I1), Next Pm Mileage (J1), Next DOT date (K1)

What I do now is every week go through and change the text red on the areas
the need attention. (I1, J1 or K1) Is there a macro or something that would
change the color from black to red or visa versa when I update the current
info?

TIA

Cindy
 
G

gumby

I have use Excel in a very limited capacity for years so I am going to try
to explain what I want the best I can. I have a spreadsheet that I created
to keep track of the services and inspections of company vehicles. This
works great but every week I have to go through each unit to high light the
units that need attention. The spreadsheet looks like the following:

Unit (B1), Last Pm Date (D1), Last PM Miles (E1), Last DOT Date (F1),Current
Miles (G1), Next Pm Date (I1), Next Pm Mileage (J1), Next DOT date (K1)

What I do now is every week go through and change the text red on the areas
the need attention. (I1, J1 or K1) Is there a macro or something that would
change the color from black to red or visa versa when I update the current
info?

TIA

Cindy
Click to expand...

What determines if it needs to be highlighted? Do you have a set
standard. You could just use conditional formating.

David
 
C

Cindy Conover

Sorry, I should have included that.
I1 is 90days later than D1
J1 is 20,000 miles later than E1
K1 is 360 days later than F1
so I need to know if any unit is past the three columns miles, or time.

Cindy
 
S

Stan Brown

Thu, 17 May 2007 14:02:46 -0500 from Cindy Conover
What I do now is every week go through and change the text red on the areas
the need attention. (I1, J1 or K1) Is there a macro or something that would
change the color from black to red or visa versa when I update the current
info?
Click to expand...

Format > Conditional Formatting and select the "formula" option.
 
C

Cindy Conover

Jordon,

Thank you so much, this opens a whole new group of possiblities for me.
Keep up the good work.

Cindy

"Jordon"
 
C

Cindy Conover

T800 & W9L. 13 weeks or 20,000 miles whatever comes first. I have been
lucky enough not to have had to go through a DOT audit. But I have had the
DOT state mileage audit before.
Is that a KW on your website?

Cindy
 
C

Cindy Conover

Jordon,

I have the mileage column working beatifully. But I am having a problem with
the DOT due date. The format in the due column(J4) is F4+365. If I try to
do a conditional format I turn the whole cloumn "blue". Do I need to have
today's date in the format somewhere?

cindy


Cindy Conover said:
I work in a KW dealership on the rental and lease side.
Click to expand...
 
Top