FatalLordes
New Member
- Joined
- Dec 22, 2017
- Messages
- 26
... I'm having a brain fart moment and for the life of me can't figure it out.
I have the following:
What I want to do is look at cell B23 and if it is LESS than B10 (and would be coloured red if it was), do nothing as I'm not interested in negative numbers. But if it MORE than B10 (and would be coloured black), I want to do B23 - B10 and assign the value to K23 with the formula K23 = K23 + whatever B23 - B10 is. Then I want to do the same for C and then D, etc, but all adding to K23. So essentially K23 will be the value to the other cells added together but only if row 23 is MORE than row 10 (but looking at individual cells). I hope I explained that correct. So for row 23, the value of K23 at the end would be $520.82.
If it helps, I did do conditional formatting which when the value is less than that in row 10 it is coloured red.
I'm just hitting brick walls when I try to do this so would truly appreciate some help
I have the following:
What I want to do is look at cell B23 and if it is LESS than B10 (and would be coloured red if it was), do nothing as I'm not interested in negative numbers. But if it MORE than B10 (and would be coloured black), I want to do B23 - B10 and assign the value to K23 with the formula K23 = K23 + whatever B23 - B10 is. Then I want to do the same for C and then D, etc, but all adding to K23. So essentially K23 will be the value to the other cells added together but only if row 23 is MORE than row 10 (but looking at individual cells). I hope I explained that correct. So for row 23, the value of K23 at the end would be $520.82.
If it helps, I did do conditional formatting which when the value is less than that in row 10 it is coloured red.
I'm just hitting brick walls when I try to do this so would truly appreciate some help