Forum Discussion
Strange conditional formatting results being returned
It's puzzling why blank cells are being formatted also...
Using....
Format only cells that contain
Cell value / greater than / =I5
Fill colour = yellow
There should only be one cell (70.000) highlighted
When a dummy sheet was created for testing purposes there were no issues.
Anyone any idea what is causing this?
Thanks. The cause of the problem is that the empty-looking cells in column J are not really blank. This sometimes occurs with data imported from outside Excel.
You can correct this as follows:
Select column J.
On the Data tab of the ribbon, click Text to Columns, then immediately click Finish.
The empty-looking cells should now be blank.
5 Replies
Please attach a workbook demonstrating the problem. The screenshot is not helpful.
- no problem
https://1drv.ms/x/s!Ai3wejactZJ_rnlhZGoFWYUb8T-S?e=wdKu6NThanks. The cause of the problem is that the empty-looking cells in column J are not really blank. This sometimes occurs with data imported from outside Excel.
You can correct this as follows:
Select column J.
On the Data tab of the ribbon, click Text to Columns, then immediately click Finish.
The empty-looking cells should now be blank.
- If you don't see the image I uploaded please let me know.
