LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Quinn Ramsey
 
Posts: n/a
Default Formula in a writable field

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide formula skateblade Excel Worksheet Functions 10 October 15th 05 08:36 PM
Can a formula be used in the Criteria field of SUMIF?? peter Excel Worksheet Functions 1 October 15th 05 12:14 PM
ISBLANK Formula Help Request John C. Harris, MPA Excel Worksheet Functions 4 July 22nd 05 10:06 PM
Named SUM Formula with relative refernce(s) Werner Rohrmoser Excel Worksheet Functions 2 April 20th 05 04:56 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM


All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"