In column A I have some numbers. I have a helper column in column CU that checks if the value in that row is the same as the above, if not, then it returns FALSE, else TRUE. I have made conditional formatting for this, and it hightlights the rows with a solid background color if its true or false, each with a different color. This ALSO Works and shall also work when I insert a row below and copy the above row Down to that new row.
Now I would like to remove this solid background color and instead put a line underneath or above the rows. I have made some attempts, but I can't get it working when new rows are inserted and the above row is copied Down to that empty row.
How can I make this separation with a line instead of this solid background color?