Conditional formatting in range

  • Thread starter Thread starter RE: VLOOKUP fORMULA
  • Start date Start date
R

RE: VLOOKUP fORMULA

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
 
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.
 
Back
Top