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 |
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 |