Forum Discussion
Solved
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 c...
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.
no problem
https://1drv.ms/x/s!Ai3wejactZJ_rnlhZGoFWYUb8T-S?e=wdKu6N
https://1drv.ms/x/s!Ai3wejactZJ_rnlhZGoFWYUb8T-S?e=wdKu6N
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.
- Amazing!!
Just learned something new today.
Thank you