I want to format a number in a particular cell based upon the value of another cell in different worksheet within the same workbook. For example, I have an index worksheet in my workbook that uses a particular index cell whose value changes depending upon the units of measurement that have been selected by the user when entering a particular value. If the value of of this index cell (Worksheet4! $B$1) is 1, then I want the format of the number in Worksheet2 $L$5 to be 0.0000; and if the value of Worksheet4! $B$1 is 2, then I want the format of the number in Worksheet2 $L$5 to be 0.00; and if the value of Worksheet4! $B$1 is 3, then I want the format of the number in Worksheet1 $L$5 to be 0.0; and if the value of Worksheet4! $B$1 is 4, then I wan't the format of the number in Worksheet2 $L$5 to be 0.0.
I haven't been able to figure out how to program this. (I'm using Excel 2011.)
Bookmarks