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?
It’s puzzling why blank cells are being formatted also… Using….Format only cells that containCell 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? Read More