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...
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
Strange. Please check attached, both variants are here
- 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