Clear Google Sheet Cell contents based on another cells value

1
votes

I have an issue with my google sheet. I'd like to clear the contents of a cell based on the value of another cell.

For example, I have a drop-down list in cell H3. If the value in cell I3 is 29 or 36 I need the contents of cell H3 to disappear. The ability to use the drop-down menu in H3 should remain for use at a later time.

Currently, I have H3 conditionally formatting to change the font white in H3 when 29 or 36 appear but this is obviously a bit rubbish. I have tried dependent lists using =INDIRECT but they don't update immediately or automatically and you soon become trapped. Any other ideas?

Thanks

1
google-sheets

1 Answers

0
votes

you can create proxy drop-down controlled with IF():

=IF(OR(I3=29, I3=36), ,{L3:L})

1