Hi, I've got a worksheet showing figures for 2002 that has the corresponding values for 2001 hidden on alternate rows ie
row 10 2002 figs
row 11 2001 figs(hidden)
row 12 2002 figs
row 13 2002 figs (hidden)
The conditional formatting for 2002 is based on comparisons with 2001,but I want to leave 2001 unformatted. When I drag the conditional formatting across the 2002 rows it also applies to the hidden 2001 rows. Is there a way to avoid this, so the hidden cells don't pick up the fromatting meant for the visible cells?
row 10 2002 figs
row 11 2001 figs(hidden)
row 12 2002 figs
row 13 2002 figs (hidden)
The conditional formatting for 2002 is based on comparisons with 2001,but I want to leave 2001 unformatted. When I drag the conditional formatting across the 2002 rows it also applies to the hidden 2001 rows. Is there a way to avoid this, so the hidden cells don't pick up the fromatting meant for the visible cells?