Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Conditional Formatting
Thanks guys both of these worked....
But I now have a related problem. If I have all Cond formatting based on other columns I can sort by any column and the colours move with the cells. All good so far. When I remove the Cond format and add the colour myself, if I sort the colour doesn't move with the cell. The cell re Cond formats itself. I need the colour to stay with the cell if that's possible?? Thanks again Judith "Ron de Bruin" wrote: Hi Judith You can use this Range("A1:A10").FormatConditions.Delete -- Regards Ron de Bruin http://www.rondebruin.nl "JudithJubilee" wrote in message ... Hello All, I have lovingly conditionally formatted all the columns in a spreadsheet (with background colours) and now need to be able to override this in some cells (with a different background colour). I know I can highlight + Cond Formatting + Delete 1,2 & 3 and then choose my colour but obviously there must be a quicker way... I tried to record a macro using the steps above but it only recorded the choosing a colour at the end not the deletion of the Cond formats, so no help. I thought there might be some code that would delete all Cond formatting? All help gratefully received. Judith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing formatting | Excel Discussion (Misc queries) | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Removing % sign, but keeping the formatting | Excel Discussion (Misc queries) | |||
Removing formatting | Excel Discussion (Misc queries) | |||
Removing conditional formatting if it exists | Excel Programming |