Conditional formatting, highlight alternating values

Microsoft corporation Office 2010 profes...
January 6, 2015 at 04:06:44
Specs: Windows 7
Hello all

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?

See More: Conditional formatting, highlight alternating values

Report •

January 7, 2015 at 13:31:01
Okay I found this site:

She shows how to do it, altho I had to set the seperator line at the cells buttom and not the top.

Report •
Related Solutions

Ask Question