G
Guest
I've got some conditional formatting that looks at values
in two columns. When I delete a column preceeding those
two columns (and shift cells left), the conditional
formatting for both columns moves left one column.
How can I fix the conditional formatting so that it
remains fixed on the same two columns?
=AND(N16<100, O16<100)
in two columns. When I delete a column preceeding those
two columns (and shift cells left), the conditional
formatting for both columns moves left one column.
How can I fix the conditional formatting so that it
remains fixed on the same two columns?
=AND(N16<100, O16<100)