Conditionally formatted ranges

  • Thread starter Thread starter KimC
  • Start date Start date
K

KimC

Is it possible to insert a row into a conditionally formatted range and have
the formatting of the range be copied to the row?
 
KimC,

If you insert the row in between the range of conditional formats, the
conditional formats will be inserted as well.

Test:
A1:1
A2:1
A3:2
Conditional Format: Cell Value = 1, Bold
Insert row between A2:A3

A1:1Bold
A2:1Bold
A3:1Bold (new row)
A4:2
 

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

Changes in How Code Acts After Upgrade of Excel 2
Excel VBA 1
Excel Conditional Formatting Removal 7
Conditional Formatting with VBA 4
Copying Row Code Doesn't Copy Conditional Formating 10
VBA Conditional Formating Using Logical Expression 4
Conditional Formatting 1
Excel Macro to automatically go to the right of the last colored cell 0

Back
Top