View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
VLOOKUP fORMULA  VLOOKUP fORMULA is offline
external usenet poster
 
Posts: 32
Default Conditional formatting in range

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