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?