Hi, greeting to all of you out there!!
I have a YES/NO q-tion to ask.
What should I do to make the "row 2" numbers or charaters appear or not to appear based on "decision" row "Yes/No" ?
appear mean = is not there, until I type "Yes".
Example file attached.
Use Conditional Formatting:
In cell D4, click Format>Conditional Formatting..., select "Formula Is" in the Condition 1 box and enter this formula in the formula box:
=$E4="no"
Then click the format button and change the font color to White. Click OK twice. Now copy this cell and Paste Special>Formats to the range desired (E5:E??).
Any cell in Column E that has "no" will cause the cell in Col D to have white font (invisible).
HTH
Bruce
The older I get, the better I used to be.
USA
Format to white mean = the figures/charaters is there, but you can't see it.
What I want is the the cell should be EMPTY until I type yes into the "decision" cell. If "no" was key in, nothing should change.
thanks
davidtips
Then use an IF statement:
=IF($E4="Yes",C4,"")
This will look E4. If it is empty or contains anything except "Yes", it will be blank. If E4 =Yes, it will return the value in C4. Of course, you can modify the C4 entry to anything you desire (e.g. A1+B1, etc.)
HTH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks