In general a common side effect of INDIRECT is that inserting row/columns
can cause havoc because the reference cannot change when the insert is made.
It is the nature of INDIRECT and indeed some people reply on this feature
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"tino2009" wrote in message
...
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