Conditional formatting in range

  • Thread starter RE: VLOOKUP fORMULA
  • 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
 
B

Brigette

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert a row and keep the conditional formatting 1
Conditional Formatting Range 5
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Question about conditional formatting of zeros in Excel 0
Conditional Formatting 3
Conditional Formatting assistance 7
conditional formatting 1
Conditional formatting in a formula 1

Top