See answer to same request in other group.

Not necessary to multi-post.


Gord Dibben Microsoft Excel MVP

On Sun, 28 Aug 2011 18:27:18 -0700 (PDT), magmike
wrote:

I would like to have a column that records the date that another
column ("Status") was populated with a value.

The column titled "Status," when populated with a value, marks the row
a certain color depending on the text entered in the field. For
example, if I enter "cb" (meaning 'call back') the row turns a light
yellow. There are about 10 different possibilities that could be
entered and colors that correspond with the entered text.

Regardless of the text entered into the "Status" column, I would like
another column's field in the same row to be automatically populated
with that day's date when the "Status" column is first populated
(regardless of the entered text) AND I do not want that date to ever
change, even if the text of the "Status" column is changed or
deleted.

Is this possible?

Thanks in advance for your help!

magmike