Forum Discussion
Custom Sorting with Highlighted Rows
Hello all, I am working with a very large data set that has Column C, in which every cell says "PAID" or "PENDING." See Image 1 below: I created a valid conditional formatting by creating a cell ...
micromaximilian Apply the rule to rows $2:$1048576, since the first data row is row 2.
Demonstrated in the picture below, though on a slightly smaller scale.
By the way, do you really need to set the rule to cover over I million rows?