Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like to set up a cell so that it can be either a writable field or it
will pull from a formula depending on other things in the spreadsheet. More specifically, if the current date is after a point I want the field to display data from a formula, but if it the current date is before that date I want it to be a writable field that the user can input data with. I know how to do some stuff with the date with conditional formatting or with a formula itself. But I don't know how to make a cell both writable and come from a formula depending on other things. Thanks -Quinn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide formula | Excel Worksheet Functions | |||
Can a formula be used in the Criteria field of SUMIF?? | Excel Worksheet Functions | |||
ISBLANK Formula Help Request | Excel Worksheet Functions | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |