| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format top row, but only non-blank cells
here's what i did and it works....I took some code i found in an earlier
message and modified it slightly. Sheets("dbo_Corp10_Demographics_Volume_").Select Range("A1", Range("IV1").End(xlToLeft)).Select ''''''''Rows("1:1").Select-----I replaced this line with the one above With Selection.Interior .ColorIndex = 15 .Pattern = xlSolid |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format for Blank Cells | Excel Worksheet Functions | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| Conditional formatting: format when range of cells are blank | Excel Discussion (Misc queries) | |||
| Blank Cells - conditioning format | Excel Discussion (Misc queries) | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
Hybrid Mode
