Hi All,
Just wondering if someone could help me interpret this formula please?
=IF(A2=0,SUM(INDEX(A:A,MAX(IF($A$1:A1=0,ROW($A$1:A1)))+1):A1),"")
I am trying to piece it together because I think it will help me with another project I am trying to build
Ideally; I am tying to....
____A____B___
1 10
2 10
3 10
4 10
5 10
6 10
7 11 <--Conditional Format;Cell Color=RED if =SUM(OFFSET(A7,-6,0,7,1)>70)
AND/OR
____A____B___
1 10
2 70
3
4 10
5 10
6 10
7 11 <--Conditional Format;Cell Color=RED if =SUM(until blankcell)>70
Thanks heaps
Nelg
Bookmarks