| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to make identical cell datas active to allow changes
What you propose is very powerful.
Even implementing it in VBA completely eliminates the need for a loop. -- Gary''s Student - gsnu200821 "Gord Dibben" wrote: Without formulas or VBA............... Select all then EditFind What: your data Find All In the "found" dialog select top cell then SHIFT + End + Downarrow To change format, hit FormatCells and make the format change. To change data hit F2, make changes then CTRL + ENTER Gord Dibben MS Excel MVP On Sun, 21 Dec 2008 05:11:00 -0800, caprey wrote: How to create a command formula that could allow me activate cells containing identical data thus make changed data or color fill? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i make a chart follow the active cell | Charts and Charting in Excel | |||
| make one cell identical to another | Excel Worksheet Functions | |||
| Looking Up Datas when Key Values are Identical | Excel Worksheet Functions | |||
| How do I make it so that the active cell follows the cursor keys? | Excel Discussion (Misc queries) | |||
| How do I make the border of an active cell in Excel darker? | Excel Discussion (Misc queries) | |||
Threaded Mode
