Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to see todays date in cell A1 if I type any thing in cell B1, and I
want that date to stay same until I delete the value in cell B1 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
That would not be Conditional Formatting
From John McGimpsey................... Using circular references and worksheet functions You can use a circular reference to enter the time when a change is made in another cell, then maintain that time. Choose Tools/Options/Calculation (Preferences/Calculation for Macs) and check the Iteration checkbox. Then, if your target cell is A1 and you want the date/time to appear in A1, enter this in A1: =IF(B1="","",IF(A1="",NOW(),A1)) Format A1 as you wish to display date, time, or both. If B1 is initially blank, A1 will return a null string (""). When a value is entered into B1, A1 will evaluate as "", therefore NOW() will be returned. After that (as long as B1 remains populated), A1 will evaluate to a date/time and therefore will return the value in A1 - i.e., the date/time. .................................................. . Gord Dibben MS Excel MVP On Tue, 24 Jun 2008 16:58:01 -0700, Kimti wrote: I want to see todays date in cell A1 if I type any thing in cell B1, and I want that date to stay same until I delete the value in cell B1 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you very much for your help. It worked.
"Gord Dibben" wrote: That would not be Conditional Formatting From John McGimpsey................... Using circular references and worksheet functions You can use a circular reference to enter the time when a change is made in another cell, then maintain that time. Choose Tools/Options/Calculation (Preferences/Calculation for Macs) and check the Iteration checkbox. Then, if your target cell is A1 and you want the date/time to appear in A1, enter this in A1: =IF(B1="","",IF(A1="",NOW(),A1)) Format A1 as you wish to display date, time, or both. If B1 is initially blank, A1 will return a null string (""). When a value is entered into B1, A1 will evaluate as "", therefore NOW() will be returned. After that (as long as B1 remains populated), A1 will evaluate to a date/time and therefore will return the value in A1 - i.e., the date/time. .................................................. . Gord Dibben MS Excel MVP On Tue, 24 Jun 2008 16:58:01 -0700, Kimti wrote: I want to see todays date in cell A1 if I type any thing in cell B1, and I want that date to stay same until I delete the value in cell B1 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks for the feedback and thanks to John.
Gord On Tue, 24 Jun 2008 17:41:00 -0700, Kimti wrote: Thank you very much for your help. It worked. "Gord Dibben" wrote: That would not be Conditional Formatting From John McGimpsey................... Using circular references and worksheet functions You can use a circular reference to enter the time when a change is made in another cell, then maintain that time. Choose Tools/Options/Calculation (Preferences/Calculation for Macs) and check the Iteration checkbox. Then, if your target cell is A1 and you want the date/time to appear in A1, enter this in A1: =IF(B1="","",IF(A1="",NOW(),A1)) Format A1 as you wish to display date, time, or both. If B1 is initially blank, A1 will return a null string (""). When a value is entered into B1, A1 will evaluate as "", therefore NOW() will be returned. After that (as long as B1 remains populated), A1 will evaluate to a date/time and therefore will return the value in A1 - i.e., the date/time. .................................................. . Gord Dibben MS Excel MVP On Tue, 24 Jun 2008 16:58:01 -0700, Kimti wrote: I want to see todays date in cell A1 if I type any thing in cell B1, and I want that date to stay same until I delete the value in cell B1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formating based on Date | Excel Worksheet Functions | |||
Conditional Formating based on a different cell | Excel Discussion (Misc queries) | |||
Conditional Formating Based on Date | Excel Discussion (Misc queries) | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) |