 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2007Find based on cond. 4matting? Replace as ALT-Enter? (2 diff prob
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 Press Alt and key in 0010 on the keypad. > 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 [quoted text clipped - 9 lines] > > -Cate 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 > Press Alt and key in 0010 on the keypad. > [quoted text clipped - 11 lines] > > > > -Cate To remove all Conditional formatting, just select area of cells, click Format, Conditional Formatting.. , Delete, tick 1 2 and 3 and OK, OK. > 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 -- [quoted text clipped - 17 lines] >>> >>>-Cate 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 >To remove all Conditional formatting, just select area of cells, click >Format, Conditional Formatting.. , Delete, tick 1 2 and 3 and OK, OK. [quoted text clipped - 20 lines] >>>> >>>>-Cate Sorry, I understood to not change any of the cell formatting, not the results of the Conditional formatting. > Bob > [quoted text clipped - 29 lines] >>>>> >>>>>-Cate 1. Chip's Pearson's site has UDF's to return the CF colors so's you can find them http://www.cpearson.com/excel/CFColors.htm 2. Alt + 0010 on Numpad or use CTRL + j Gord Dibben MS Excel MVP >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 [quoted text clipped - 9 lines] > >-Cate If you're converting the formulas to values--so you don't care about the formulas, you may want to try this. Open a new MSWord document (yep, MSWord) Select the range to copy in excel edit|copy Paste into MSWord Remove the format|Conditional formatting from that range copy and paste from MSWord back into excel. If the range is large, you may have to do this in bite sized pieces. Heck, if the range is small, you may just want to keep it in MSWord????? > 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 [quoted text clipped - 9 lines] > > -Cate  SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.