Forum Discussion
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...
Monica, use
=($A2<>$B2)
Otherwise you always compare A2 and B2, for any cell to which the rule is applied
- Why did it work when I used the format painter?
What do you mean it works? - last cell in your sample is highlighted or not?
- The last cell is not highlighted
