LinkBack URL
About LinkBacks
Hi everyone I have a problem with RUNNING TOTALS and CONDITIONAL FORMATTING
I know there are a lot of bright minds on this forum and I know you can solve my problem.
I have attached a document so you guys can see what I am hoping to achieve.
Hi everyone I have a problem with RUNNING TOTALS and CONDITIONAL FORMATTING
I know there are a lot of bright minds on this forum and I know you can solve my problem.
I have attached a document so you guys can see what I am hoping to achieve.
I would suggest manually doing an example to help clarify.
This way we know where you want the totals to be listed, and clearly what colors would be applied, and when.
Please click the * icon below if I have helped.
Without seeing some sample data and sample answers, not easy to see what you want?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Wow thank you guys for replying I truly appreciate it. I have updated the excel workbook and have tried to explain what I am hoping to achieve.
If you guys need any additional information please do not hesitate to ask. Once again thank you guys you are legends!!!!
Kind RegardsTonys Service Register 2014 update.xlsx,
Wessel
in F2 you can use
=E2-MAX(K2:AO2)
that will give you the last Max entry in K to AO and subtract from due
then for conditional formatting
green = F2>50
Orange = F2 >12
Red =F2<=12
in that order and stop if true
see attached - is that what you need ?
Not sure how D2 fits in
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.
Mate that is 100% spot on!!! D2 is just a reference for myself, to see what the service intervals is between services. You will see on the Sheet "Equipment" that I have no date formatting inside cell "F2:F4" as I have no clue on how to do that. You are a true legend!!! I would have to buy you a burger and a pint! PM me your PayPal email address and tell me how much a burger and a pint costs in the UK and I'll send it to you. Once again thank you so much!!!!!
your very welcome. No need for any payment here its a free service , although they do have a commercial section
however,
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks