View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
magmike[_2_] magmike[_2_] is offline
external usenet poster
 
Posts: 35
Default Wierd Formula Request

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