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 column B that aren't equal to column A
| LTD | System LTD |
| 119.18 | 119.31 |
| 103.87 | 104.04 |
| 104.65 | 104.80 |
| 82.68 | 82.85 |
| 125.48 | 125.61 |
| 148.92 | 148.92 |
The conditional formatting I used is =($A$2<>$B$2) and had it apply to =$B$2:$B$7
I would like it to show as red font - not highlight the cell.
Does it matter if column B contains a formula? Thanks!
7 Replies
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?
