Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Background color for 50,000 odd-numbered rows
Hi,
I have a worksheet which has over 50,000 rows of data and 10 columns. I would like to appy background color to all this data to make it easy to read. Here is what I need: a. All the odd numbered rows in the range a5:j50004 should have a gray background color. b. All the even numbered rows in the range a5:j50004 should have a yellow background color. c. This color scheme should remain when existing rows are deleted from this range. d. This color scheme should remain when new rows are inserted into this range. Please show me the VBA code to do all of the above. In what part of the spreadsheet should this code reside? Thanks. Luther ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
find excel rows with a background color | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
Excel 2003 Font Color and Background Color | Excel Discussion (Misc queries) | |||
can you select rows in excel with a certain background color? | Excel Worksheet Functions |