| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternate Shading for non-bold rows
On Mar 24, 10:56*am, joel wrote:
Your is only checking column A for shading from If IsNumeric(ThisWorkbook.Sheets(1).Cells(rw.Row, 1)) to if ThisWorkbook.Sheets(1).Cells(rw.Row,1).interior.co lorindex < xlnone -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=190077 http://www.thecodecage.com/forumz Hi Joel, thank you very much for your tip. It help me to solve my problem. Thank you again. Regards, Andreas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I alternate shading of rows, Excel 2007, no new tabs. | Excel Discussion (Misc queries) | |||
| Alternate Row Shading (Visible Rows Only) | Excel Worksheet Functions | |||
| Shading alternate "groups" of rows? | Excel Worksheet Functions | |||
| shading alternate rows, but losing format when one row is deleted | Excel Discussion (Misc queries) | |||
| Alternate Shading | Excel Discussion (Misc queries) | |||
Threaded Mode
