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

Conditional formatting with dates 7
Conditional Formatting assistance 7
Comparing two columns with conditional formatting 4
Copying Conditional formatting 2
Conditional Formatting in Excel 2003 2
Using Format Painter with Conditional formatting 0
Conditional Formatting Training Expiry Dates 2
Conditional formatting disappears when cell contents deleted 2

Top