Ladies and gentlemen; good morning.
Is it possible to select a number of cells that are say yellow when blank but once someone type "N" or "No", they change to blue and if "Y" or "Yes" they change to green.
I tried conditional formatting but it does not change the blank range to yellow until I have entered something into it.
Does anyone know how to code this VBA?
Thank in advance