Previous Topic Next Topic

COLOR CHANGE AND CONTINUAL TOTAL...EXCEL!!!!

Closed
winniw - May 19, 2010 at 03:35 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 19, 2010 at 04:40 PM
Hello,


I am begging for help !!!!

I will explain what I need and then hopefully you can help me.

FIRST ISSUE:

If Cell F9 = E9 do nothing
If Cell F9 is less than or greater than E9 then turn the cell red

i need this to happen for 30 rows

do i put this in a cell outside of the data area? like in cell zz100?

SECOND ISSUE:

i want to have a running total for 30 rows of odometer readings in a blue box i created labeled "total mileage".

so 5-5-2010 reading 1000
5-6-2010 reading 1100
5-7-2010 reading 1350

what do i do to have it take 5-6-2010 minus 5-5-2010 and add it to 5-7-2010 minus m-6-2010?
I tried this =(b2-b1)+(b3-b2)+(b4-b3)
but i need this to be continues for 30 rows. so if row 5 is empty i only need the formula to add to that point.

please please help me :)
Related:

2 responses

Answer 1 / 2
timoteo515 Posts 3 Registration date Wednesday May 19, 2010 Status Member Last seen May 19, 2010
May 19, 2010 at 03:44 PM
TRY TO DO IT IN EXPONENTS.
0
winniw
May 19, 2010 at 03:47 PM
How do you do that? I have been trying to do this for 3 1/2 hours now....at this point i don't even know if i can remember how to do sums :)
0
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 19, 2010 at 04:40 PM
Your First Issue, for color part, you can use conditional formatting

1. Select the rows/cells on which you want this to apply. Lets say it is from F9-F39, so select cells F9 thru f39

2. go to conditional formatting and enter this formula
=AND(F9<> "", F9<>E9) and then click on Format in the conditional format and choose red color


For your second issue, could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
0