Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find based on cond. 4matting? Replace as ALT-Enter? (2 diffprob
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find based on cond. 4matting? Replace as ALT-Enter? (2 diff
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find based on cond. 4matting? Replace as ALT-Enter? (2 diff
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find based on cond. 4matting? Replace as ALT-Enter? (2 diff prob
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 On Thu, 17 May 2007 09:52:03 -0700, 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find based on cond. 4matting? Replace as ALT-Enter? (2 diff
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find based on cond. 4matting? Replace as ALT-Enter? (2 diff prob
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????? 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 -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find based on cond. 4matting? Replace as ALT-Enter? (2 diff
Sorry, I understood to not change any of the cell formatting, not the
results of the Conditional formatting. Gord Dibben wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quickest way to find/replace based on values? | Excel Worksheet Functions | |||
find replace in multiple sheets based on namebox | Excel Discussion (Misc queries) | |||
Adding values from 1 col based on value in diff col | Excel Discussion (Misc queries) | |||
why cond sum wizard returns diff result as when formula typed out | Excel Worksheet Functions | |||
how to use the Prob function in a list of averages to find the le | Excel Worksheet Functions |