When I fill cells with colour some cells appear to fill just the cell and some fill the cell and the border/gridline.
I have tried adding and deleting borders and altering the colour fill via conditional formatting.
However I can see no difference between affected cells' settings.
Please could someone advise how to prevent this happening?
Thank you!
Difficult to tell exactly what is causing it from just a screen shot, but my guess is that it is the border setting from the cells below the red cell that is actually the issue.
Here I recreate the problem with cell F12 having a custom border while cell G12 does not have any:
So try highlighting both of your "Y" cells at the bottom of the red "N" cells, then select Borders -> Clear Borders
If above works, then my recommendation will be to Clear Borders for all cells (if your sheet is not too complex already) and then start your formatting again.
After OP provided a link to the sample Google Sheet, it is clear that the issue is that the cell below (i.e. cell A4 in the sample) had a White fill colour, while cell B4 did not.
If the fill in A4 is Reset (cleared) then the red fill in A3:B3 will match. To illustrate this point, I duplicated the OP's A1:B5 range to A8:B12, then Reset (cleared) the fill colour in A11:B12. As screen shot shows, the red fill in A10:B10 then appears as identical.
When referring to "select Borders -> Clear Borders", in your comment you mentioned:
Sadly, it does not work for me.
To fix the issue you should clear the fill of the cell bellow and next to the cell in reference.
Why?
Because in either a cell is filled with white or is reset, the Fill colour shows White.
This can be confusing, but...
