ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 326
- Office Version
- 365
- Platform
- Windows
I have data which is populated using the filter function from another table.
I am trying to condionally format the cells in a row where the data in Column C is greater than Columns B
I entered =C2>B2 in the folrmula bar but it randomly formats cells. Is it because the results in the cells are not actually numbers.
I would have expected row 2 and 4 to be formatted
I am trying to condionally format the cells in a row where the data in Column C is greater than Columns B
I entered =C2>B2 in the folrmula bar but it randomly formats cells. Is it because the results in the cells are not actually numbers.
I would have expected row 2 and 4 to be formatted