I have a large file and need to conditional format the color, I understand how this works . Now, I only want to keep the colouring, not the data. Is this possible?
When I delete the data in the colouring formatted cells, the color will dissapear too. How can i keep only the coloring format? I want to be able to put text in the colored cells afterwards....
When I delete the data in the colouring formatted cells, the color will dissapear too. How can i keep only the coloring format? I want to be able to put text in the colored cells afterwards....