I have one excel file which has Detail tab. It has Total Amount column. Now i need to draw the line if the first few row total becomes more than 50000. I need to draw the line on that Raw where sum of Total Amount > 50000.
Is there any way by conditional formatting or by macro?Example_Drawline.xlsx