Mar 20 2022 06:44 AM
I've a simple spreadsheet with a column of 3 numbers:
-15.3, 9.67, and 22.14.
I've created two rules (with color) with number formats with 0 and 2 digits. When the named cell TT_R is 0, I want whole numbers. When the cell is non-zero, I want 2 digits.
However (as shown above) the first rule (TT_0=0) never seems to fire!
Why and any ideas?
Mar 20 2022 07:39 AM
SolutionMar 21 2022 08:18 AM
Mar 20 2022 07:39 AM
SolutionThe formula in the rule should be
=TT_R=0
without quotes, i.e. not
="TT_R=0"