Forum Discussion
fatalpotato_1389
Jun 29, 2024Copper Contributor
HELP! Formula or Conditional Formatting?
Hi! I am coming across a road block and it seems like what I am trying to do is simple enough, but everything I have tried does not work. I am wondering if maybe it's because there is already a formu...
fatalpotato_1389
Jun 30, 2024Copper Contributor
Thank you for the reply. Unfortunately that did not work 😞 Basically, what I wanted was, when A10 is blank, I want B10 to be blank as well but I guess it may not work out the way I wanted.
Thank you anyway!!
Thank you anyway!!
HansVogelaar
Jun 30, 2024MVP
Sorry, my mistake. Option 1 should have been
Select B10 and enter the formula
=IF(A10="", "", B2)
Select B12 and enter the formula
=IF(A12="", "", B2)