Forum Discussion

Monica Bossert's avatar
Monica Bossert
Brass Contributor
Aug 18, 2017

Conditional Formatting - Column A contains #, Column B contains a formula, formatted as a #

Hello,   My column A has numbers, but my column B has a formula, and the column is formatted as number. It isn't working for me when I try and use conditional formatting to highlight the numbers in...
Formulas & Functions
Need Help
Monica Bossert's avatar
Monica Bossert
Brass Contributor
Aug 18, 2017
The last cell is not highlighted
  • Monica Bossert's avatar
    Monica Bossert
    Brass Contributor
    Aug 18, 2017
    The last one shouldn't be highlighted though as the value in A and B is the same

    B2 to B6 highlighted like they were supposed to
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Aug 18, 2017

      Shall not work with absolute references.

       

      Anyway, as for the font in the rule Format -> Font -> Color

Resources