| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unchecking "Extend data range formats" is not workingfor row shading
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Here is the solution:
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
| How to Match and Sort two range of data? | New Users to Excel | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Linear Mode
