Unchecking "Extend data range formats" is not workingfor row shading

P

PLG

I have rows that are shaded a color. I would like new rows I insert to not be shaded.

I unchecked "Extend data range formats and formulas", but new inserted rows are still shaded.

I unchecked Tools/Auto Correct/Auto Format/"Include new rows and columns in list" but that didn't help either.

How can I make the default fill color for new rows inserted between two shaded rows be "no fill"?


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
P

PLG

Col F contains a unique value, "C", or an empty cell.

Select all rows or upper left to lower right cells
Format/Conditional Format
change "Cell Value Is" to "Formula Is"
enter =$F1="C" then select Format/Patterns and a color

Click Add and change Condition 2 to "Formula Is"
enter =$F1="" and select Format/Patterns and the "No Fill" option

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 

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

How do I maintain alternate row shading after inserting a new row 4
shading alternate rows, but losing format when one row is deleted 8
Shading alternating rows for easy visibilty - won't stay alternating when filtering 2
Auto update row numbers after inserting new row 4
finding and then moving entire row to new sheet based on cell value 2
Automatically Extend Formula in Count function with Additional Row 3
row insertion and formatting default 1
Extend Formula not working 5

Top