Bob

This will not aid in "leaving the formatting"?

OP must first, manually or via VBA, color the cells to the CF format before
deleting the CF conditions.


Gord Dibben MS Excel MVP

On Thu, 17 May 2007 13:47:15 -0500, Bob I wrote:

To remove all Conditional formatting, just select area of cells, click
Format, Conditional Formatting.. , Delete, tick 1 2 and 3 and OK, OK.

HopefulTraveller wrote:

Awesome, Bob I. When I think of the years I've puzzled over this!!!!!!!
Is it too greedy of me to hope you also have an answer for my 1st issue --
leaving the formatting, while removing the conditional formatting formulas
from cells?
-Cate

"Bob I" wrote:


Press Alt and key in 0010 on the keypad.

HopefulTraveller wrote:


1- I've used Cond 4Mat to color a whole bunch of cells in my sheet. I now
what to do a Find/Replace based on Finding the different colored cells, which
I can't do, because Find is color-blind to Cond4Mat colors.
When data's generated by formulas in cells, I can copy & paste text to get
rid of the formulas. I'd like to keep the color & get rid of the Cond4Matting
once it's been executed. Any way?

2- I can find or replace with ^l, ^p, ^t, etc., etc., which ability has been
quite powerful for me. I have not, however, found a way of finding or
replacing with EXCEL's NewLine entry of choice: ALT-ENTER. Can anyone supply
me with that magic pill so I can get my power back?

-Cate