Thread: How to make identical cell datas active to allow changes
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How to make identical cell datas active to allow changes
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?

Reply With QuoteReply With Quote