Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Formula Request
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Formula Request
It sure is.
What are you like at Macros? To make this work you'll need to look at the worksheet code for Worksheet_SelectionChange. Do a google search on Worksheet_SelectionChange and have a look at a few examples. Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |