I have a worksheet where there is 5 rows in a column, I have a formula which I am currently using which when an entry as been input into cell H9 of the column it greys out cells H10, H11, H12 & H13, this formula is =$H$9<>"" however this formula only works when there is an entry in H9, is there a formula which can be used to blank out any of the 4 cells from H9 to H13 when an entry has been put into any of the said cells.
Also on another column I also have the same problem but this time it requires any 2 cells of the 5 to have input into the cell and blank out the remaining 3.
Do I need to look at IF & AND formulas? Any tips would be appreciated
Bookmarks