| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Color
My spreadsheet has about 10K records all sorted in column A by a number that
may be unique or repeated several times. I would like to color code the rows (alternating yellow & white) based upon this singular or grouping of numbers in column A so that it becomes easier for the view to browse. There are way to many numerical numbers in column A do attempt any conditional formatting. Any idea of a macro or code that allows for this type of color coding on such a wide variety of numbers? Example ColA ColB ColC Color 2334 CA April yellow 2334 OH June yellow 2367 WA May white |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
| Browse Forms Controls and change TextBox color based on cell color | Excel Programming | |||
Threaded Mode
