Search : in
By :

Using nested if to blank out adjacent cells

Last answer on Jun 10, 2009 3:00:00 am BST WILLYB, on Jun 8, 2009 8:59:35 pm BST 
 Report this message to moderators

Hello,
I would like to use a formula to blank out adjacent cells if a specific value is entered
for example:

I have cells A1, B1, C1

If I put the value of "X" in any one of the cells I would like the other two cells to be blanked out.


can anyone help me with this?

Configuration: Windows XP Internet Explorer 6.0

Best answers for « using nested if to blank out adjacent cells » in :
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

mubashir aziz, on Jun 9, 2009 3:00:00 am BST

What you mean be blanked out ???? If you just want to colored or something in cells then it can be done with conditional formatting ..... but if you want to values should deleted from other cells then it will not be possible ........

First of all select cells A1 to C1

Now go in format > Conditional formatting > Condition 1: Formula is: =OR($A$1="x",$B$1="x",$C$1="x")
Select some appropriate selection to hide the values like make fonts white and background white or black ...any approach you can adopt .......


Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

   
Reply to mubashir aziz

2

WILLYB, on Jun 9, 2009 1:36:58 pm BST

What I am looking for is a way to place a character in only one of the 3 cells for example:

A1 B1 C1
x (placing an "x" in A1 causes B1 and C1 to empty)



what I have is a spreadsheet quality checklist that for each area being inspected I am to answer as follows:

A1 B1 C1
Yes No Not Applicable
x

I can not have more than one answer for each inspected scenario.

   
Reply to WILLYB

3

 mubashir aziz, on Jun 10, 2009 3:00:00 am BST

The best way to do this type of work is use of Option Buttons from Froms Tool Barr ... you can delete their name from the box and can group them in a Group Box which is also in Forms tool bar .......... you can click only one check box at a time and the remainig will become unchecked .....

Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

   
Reply to mubashir aziz
Ask your question Reply
They need your help