Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try this:
If Cells(x, y).Interior.ColorIndex = 8 Then myPattern = Cells(x,y).Interior.Pattern Cells(x, y).Interior.ColorIndex = xlNone Cells(x, y).Interior.Pattern = myPatter End If jayklmno wrote: 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 | |
|
|
![]() |
||||
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 |