Is there a non-VB conditional formula syntax to change the custom number formatting of a cell based on an external cell value. i.e.
if (A4 = 16) custom number format in cell C1 becomes #??/16
if (A4 = 8) custom number format in cell C1 becomes #??/8
if (A4 = 4) custom number format in cell C1 becomes #??/4
??
Thanks.
if (A4 = 16) custom number format in cell C1 becomes #??/16
if (A4 = 8) custom number format in cell C1 becomes #??/8
if (A4 = 4) custom number format in cell C1 becomes #??/4
??
Thanks.