LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
jacob
 
Posts: n/a
Default Can you freeze a result in a cell?

Here's the dilemma:

I have a list validation in H7. You can choose from 6 different text
values.
Below, in H8, I would like to respond "true" (or yes) if a certain 1 of
the 6 text values is EVER selected, and then not be changed by anyone
else.

For instance, if the "flagged" value is "blue", and a user ever selects
blue from the drop-down list in H7, can I create an argument that
populates H8 with "True"? And keep it as true forever, even if you go
and change H7 to another value.

Hope this makes sense. Thanks sirs and madams!

Jacob

 
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
Multiply one cell by a factor and make that result round Machel_C Excel Worksheet Functions 7 March 15th 05 08:04 PM
reference the result of a formula in a text formatted cell jpwinston Excel Discussion (Misc queries) 1 February 7th 05 05:33 PM
Problem with IF condition or vector lookup? J-Philippe Excel Worksheet Functions 4 January 15th 05 08:41 PM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 07:32 PM
Formulas appear in cell instead of formula result tommcbrny Excel Worksheet Functions 3 November 30th 04 08:44 PM


All times are GMT +1. The time now is 11:12 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"