Forum Discussion

sr4aMA's avatar
sr4aMA
Copper Contributor
Mar 20, 2022
Solved

Excel 2019 conditional format (numberformat) doesn't seem to work!

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 whol...
  • HansVogelaar's avatar
    Mar 20, 2022

    sr4aMA 

    The formula in the rule should be

    =TT_R=0

    without quotes, i.e. not

    ="TT_R=0"

Resources