Hey,

I have got conditional formatting setup on a sheet that highlights a
row based on the value in two columns (K and L). The formula for this
is;

=AND(INDIRECT("L"&ROW())="No", INDIRECT("K"&ROW())="Sent")

I have got 6 varieties of this, and it all works well and highlights
each row correctly.

However, I need to insert a new column before K - and when I do I lose
the conditional formatting. I have tried manually altering the formula
as;

=AND(INDIRECT("M"&ROW())="No", INDIRECT("L"&ROW())="Sent")

but this does not work properly for the 'AND' rules. It does work ok on
=INDIRECT("L"&ROW())="Sent" though.

Is there an easy way to insert a new column without messing up the
formatting?

Thanks


--
tino2009
------------------------------------------------------------------------
tino2009's Profile: http://www.thecodecage.com/forumz/member.php?userid=447
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=110427