4
1
I have some data from different sources that I'm trying to line up to get a good handle on which fields they have in common and which they don't. To make it easier to see rows, I set up a conditional formatting rule like this:
Rule:
=MOD(ROW(),2)=0
Applies to:
=$1:$1048576
Action:
Turn Green
This works great... until I cut and paste a block of cells in one column or another. Excel's "intelligent cut-and-paste" breaks everything, by either duplicating rules, or removing sections from the region, and I have to go fix the conditional formatting again. How can I move the data around without changing the coniditional formatting rules?
1
Possible duplicate of Excel conditional formatting fragmentation
– Fabian Schmied – 2019-01-03T08:24:18.107