Hi
I am wondering to make vehicle service year plan with
Conditional Formatting. I wanted to colour every 10,000km in related month cell according to the mileage. monthly running mileage is fixed.
appreciate if any body can help
Thanks
Buddika
Hi
I am wondering to make vehicle service year plan with
Conditional Formatting. I wanted to colour every 10,000km in related month cell according to the mileage. monthly running mileage is fixed.
appreciate if any body can help
Thanks
Buddika
try putting
=IF(FLOOR(E27,10000)<>FLOOR(D27,10000),1,0)
depending on if setout across columns
or
=IF(FLOOR(B7,10000)<>FLOOR(B6,10000),1,0)
if rows
Depends on how you are recording the mileage
this will find multiplies of 10,000 and set to that multiple
and if you compare the previous value you can set a 1 or 0
and use that in a conditional format to set the colour
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks