autoformat problem

hi,

i have an autoformat formula with the cells it applies to
but my problem is if i insert a row between the cells the autoformat is applied to
the row in the formula and the rows it applies to get messed up somehow
either the row in the formula changes
or the row it should apply to also changes
or it also adds another autoformat rule with different row in the formula and different row it applies to
(cell column does not change only the cell row changes)
the cells has values of dates

below is my formula and the cell it should apply to

if month is equal or below the current month applies red fill color and white cell color bold format
=$Z2<=EOMONTH(TODAY(),-1)+1 applies to =$Z$2:$Z$55

if month is same as current month applies yellow fill color and bold format
=AND(YEAR(TODAY())=YEAR(B2),MONTH(TODAY())=MONTH(B2)) applies to =$B$2:$Y$55

how do i stop the rows in the formula and the rows it applies to
from changing even when i insert another row?

Hi
Try to use one more condition
ROW($Z2)<=55

so i add another rule?

ROW($Z2)<=55 applies to $Z$2:$Z$55 ?

No new rule.
the same rule but with that conditions

Formula:

Please Login or Register  to view this content.

applies to =$Z$2:$Z$55

i see, thank you