Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Request | Excel Worksheet Functions | |||
Request for formula | Excel Worksheet Functions | |||
Request a formula! | Excel Worksheet Functions | |||
Formula help request | Excel Discussion (Misc queries) | |||
Excel formula issues, wierd.. | Excel Discussion (Misc queries) |