| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I blank out a cell if there is a value in a different cell
I have cells A3, A4,A5, & A6. I want to blank out A3,A4,A5 if there is a
value entered into A6. or I want to blank out A3 & A6 and force entry in A4 if something is entered in A5 or blank out A3,A5,A6 if something is in A4 or blank out A4,A5,A6 if something is entered in A3. Your help is much appreciated. Thanks A3 = Dept A4 = Class A5 = Subclass A6 = Item |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Threaded Mode
