Shows correct colour in drop down menu but does not change in cell
It may be that sheet or book, or both are locked. Right click on tab, I lock mine without a password, you may of locked it unknowingly, without a password.
Shows correct colour in drop down menu but does not change in cell
It may be that sheet or book, or both are locked. Right click on tab, I lock mine without a password, you may of locked it unknowingly, without a password.