Go to: Tools<Options<Edit tab

Make sure there is a check mark next to "Extend data range formats and
formulas".

Hope this fixes your problem.
--
-Brigette


" VLOOKUP fORMULA" wrote:

I have a range named "Range1" and have a conditional formatting putting
letters into red colour if the condition meets "K6=1"

When ever I insert a row between the range the conditional formatting
formula is not copying, every time i have to use the format painter and copy
it.

Is there any code, any body pls help me

thanks