| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternating Changing Color of Cells (a Range) across a Spreadsheet
Hi again
I want to be able to change the color of a range of cells across a spreadsheet alternating the colors ie Range(A1,H1) - Pale Blue then Range(I1,N1) Pale yellow then Range(O1,S1) Pale Blue and so on.... Any advice on this simple idea? I was hoping to be able to do something like Range(A1,H1).BackColor = RGB(192, 255, 255) but I think that was wishfull thinking... cheers Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing color of a range of cells dending up on a value in anothr | New Users to Excel | |||
| changing a range of cells throughout a 5 page spreadsheet | Excel Discussion (Misc queries) | |||
| How do I set an auto alternating row color? | Excel Discussion (Misc queries) | |||
| macro or vb to alternating row color | Excel Programming | |||
| Changing color on a range of cells | Excel Programming | |||
Threaded Mode
