Hello,
I have a spreadsheet that tracks our wholesale bait sales. Each tab represents one type of bait and tracks the sales and orders of that particular type of bait. This workbook has been working wonderfully for a couple years, but after adding a column (col. J), which tabulates a running daily total of sales, I have found a couple glitches.
One glitch I solved by revising the formulas in column J, from "IF(A226=A225,J225+F226,F226)" to "IF(A226=INDIRECT("A"&ROW()-1),INDIRECT("J"&ROW()-1)+F226,F226).
That issue I described in the following post:
https://www.excelforum.com/excel-gen...-inserted.html
Although I fixed that issue, I have now discovered I have the same issue with the formula I used in the conditional formatting of that same column J. Once I insert a new line, the formula references are not updated correctly and the highlighting is all off.
Here is the conditional formatting rule:
Conditional Formatting.jpg
I have tried applying the "INDIRECT("A"&ROW()-1)" solution above to the formula in my conditional formatting, but I haven't been able to word my formula correctly for it to work.
Hopefully, my description of the issue is clear and any help in restructuring that conditional formatting formula would be greatly appreciated.
Thank you.
Bookmarks