Delete data from a color formated cell and only keep coloring format

[AVaes]

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....

 

[Joe4]

Welcome to the Board!

Conditional Formatting is dynamic, and dependent on the data in the cell at that time. So if you remove the data, the Conditional Formatting will be automatically updated.
So with Conditional Formatting, you really cannot remove the data and leave the formatting.

You will most likely need to take a VBA approach. You may be able to use a Worksheet_Change event procedure VBA code, which is code that runs automatically when data is manually changed on your worksheet. So, in this VBA code, you would kind of recreate what the Conditional Formatting was doing (i.e. if certain conditions are met, color the cell a certain color). You could then have it do nothing/exit if the change to the cell is clearing its contents. Then it will leave what previous coloring the code had already applied to the cell.

 

[AVaes]

Welcome to the Board!

Conditional Formatting is dynamic, and dependent on the data in the cell at that time. So if you remove the data, the Conditional Formatting will be automatically updated.
So with Conditional Formatting, you really cannot remove the data and leave the formatting.

You will most likely need to take a VBA approach. You may be able to use a Worksheet_Change event procedure VBA code, which is code that runs automatically when data is manually changed on your worksheet. So, in this VBA code, you would kind of recreate what the Conditional Formatting was doing (i.e. if certain conditions are met, color the cell a certain color). You could then have it do nothing/exit if the change to the cell is clearing its contents. Then it will leave what previous coloring the code had already applied to the cell.

Ok, I will look into the Worksheet_Change event procedure. Thx for the tip!

 

[Joe4]

Ok, I will look into the Worksheet_Change event procedure. Thx for the tip!

You are welcome.
Post back, if you need any help. Just be sure to include the details!