Conditional formatting

[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)

 

[mangesh_yadav]

Well, the behaviour is perfectly acceptable, and so you just inser
empty cells after you delete them.

- Manges