| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
clear row when "yes" is selected
I've never used tables before but I think you could use the following formula: =IF(A1="NO"," ",A1) A1 would be the cell in your table. If A1 is set as NO the cell your formula is in will be blank. If A1 has any value other than NO the cell with the formula in it will show the same value as the cell in your table. Hope this helps. James -- JamesArchibald ------------------------------------------------------------------------ JamesArchibald's Profile: http://www.excelforum.com/member.php...o&userid=33284 View this thread: http://www.excelforum.com/showthread...hreadid=531632 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
| Automatically clear values from a range of selected cells | Excel Discussion (Misc queries) | |||
| How can I add only on selected Criteria only? | Excel Discussion (Misc queries) | |||
| Perform oiperations relative to initial selected cell | Excel Discussion (Misc queries) | |||
| How do I clear data in selected cells automatically | Excel Discussion (Misc queries) | |||
Hybrid Mode
