| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range: changing interior color
I have a spreadsheet that has info in columns A thru F. I am trying to write
a macro that will background color the row if the cell in column F is greater than Zero. In other words if in row 11 cell F11 is 5, I want cells A thru F of row 11 to be colored green. I have tried If F11 0 then Range("A11:F11").InteriorColor = 4 but it doesn't work. What should I do? By the way, I want this to work for values in rows 11-22. Thanks Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| color the interior of a range | Excel Worksheet Functions | |||
| Events... Changing the Interior Color | Excel Programming | |||
| Passing Back Color to Interior Color | Excel Programming | |||
| Find range by interior color | Excel Programming | |||
| Interior Cell color | Excel Programming | |||
Threaded Mode
