I have an if formula that require a user to choose a drop down in another cell. If they don't make a selection the formula doesn't calculate correctly and the formula in the cell returns False. Can I conditonally format the cell the turn red if they haven't chosen the required drop down?
Thanks