Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear color but not pattern?
I am having issues with the cell color changing and updating, and removing
pattern information in the same cell. I need to look through a data and color it a certain color and when the data is revised, I uncolor it. Users have added patterns to denote other stuff and the remove color as desribed below, also removes the pattern. Is there a way to remove the color and retain the pattern? If Cells(x, y).Interior.ColorIndex = 8 Then Cells(x, y).Interior.ColorIndex = xlNone End If Thanks, Jay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
color bar with pattern macro | Charts and Charting in Excel | |||
cell pattern - color | Excel Discussion (Misc queries) | |||
Pie Chart Color/Pattern | Charts and Charting in Excel | |||
clear pattern not gridlines | Excel Programming | |||
clear pattern but not gridlines | Excel Programming |