The formula I am using=

IF(G4=1;"HIDE";"UNHIDE")

(The G4 value comes from a combobox that is directly in the worksheet)