I have a column that has dropdown list with data validation, and its applied infinitely down that column. So I have lots of cells with the little dropdown arrow which is annoying.
Is there a way to remove that dropdown arrow....IF say "Date" or "Name" column is empty? I want the drop to to show only when I have started inputting data to that row, I will never start with the drop down, I start with date. So ideally, as soon after entering the date, the dropdown arrow appears.
Can that be done? Thanks!