Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Apply conditional formatting to empty cells

I have a set of values each with different coloured backgrounds in one coloumn that i want to copy and paste over to another column, but when i delete the values after copying and pasting them, the coloured background stays. I want to know if there is way to apply conditional formatting to empty cells so that they can be changed to white, non transparent, to replace the coloured background (or something with the same effect). I tried doing it with "contains" then "", and then a custom style, but when i opened the condition menu up again it just went back to the default style and kept the background colour. I tried "Contains" then "", which didn't work, then "Not Contains" then put in all the possible values with coloured backgrounds in perenthesies which didnt work. anyone got any ideas?