Insert a row and keep the conditional formatting

D

Dutton

Regards

I have a worksheet where users insert a row at the top of a sheet by copying
the row that was already at the top and putting the new row at the top.
(Sorry)

The row is high lighted when the user changes one cell from NO to YES using
conditional formatting. This only works once as when a new row is inserted,
the formula expands the range of the conditional formatting for some reason.

Anyone thoughts
Sorry for poor explanation,
 
B

Bernie Deitrick

Dutton,

What is your conditional formatting rule?

With a "Formula is" rule like

=$A1="YES"

I had no problem copying, pasting, inserting, etc. and keeping the CF
working properly.

HTH,
Bernie
MS Excel MVP
 

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 in range 1
Copying Row Code Doesn't Copy Conditional Formating 10
Excel 2007 conditional formatting bug? 2
Conditional formatting problem 5
Conditional Format Fragmentation 2
insert row using conditional formatting 2
Insert Row formatting 1
Conditional formatting equal values 2007 2

Top