Hello,

I have several conditions that colors my rows in different colors depending on ALOT of things :-)

The conditional formatting works perfectly, EXCEPT when I delete one of the rows in the range. Then the range of of the formatting changes and screws it a bit up...

Will for the simplicity make the range smaller than my own:

Range of format:
=$A$8;$E$100

Then if I delete lets say row 15 the range of the conditional formatting changes.
How can I "lock" the range so it won't change if I delete a row?

Thanks in advance!