I really did scour the Internet for this before posting cause I feel so dumb.
If J6 equals any number then I6 equals -------------
Only thing is, it needs to be done through conditional formatting OR in a third cell that I can hide. I can't lock either J6 or I6
Re: If j6=any number then I6=--------
betapaul,
Your thread title does not permit to understand your need, please review it to turn it more explicite.
What is the result you want in I6 when there is a number in J6.
If there is NO number in I6 what is the value for J6
Re: If j6=any number then I6=--------
Here is another instance.
If F6 equals "contacted", then I6 equals "x"
I need this formula to be placed in a hidden cell as both f6 and i6 need to be editable
Re: If j6=any number then I6=--------
Betapaul - you have been asked twice to update your thread title to accurately and concisely describe your issue... it would be appreciated if you would do so or the thread will be locked...
Re: If j6=any number then I6=--------
betapaul,
You are pleased to use this forum so please care of the rules: Title not clear
Why do suddenly appeares cells F6.
How to manage I6 versus J6 and F6.
What do mean by editable for I6, is that means that the value can be changed by the user and be modified due to I6 / F6 reason.
If yes, who is the most important
Re: If j6=any number then I6=--------
...the post title is exactly what I need, why would I change it again?
If J6="123" then I6="--------"
I need this formula to be in a third cell and it doesn't matter which one (N6 for example)...
Re: If j6=any number then I6=--------
Please read your messages.
Don’t have an account yet? Register yourself now and be a part of our community!
