Forum Discussion
Conditional Formatting
Hello, Does anyone know if it is possible to have the color fill of the cell change each time the number in the cell is changed? For example, I have a macro that changes the date in the cell every ...
How would I add a counter to the cell in a hidden sheet so that it appears on the sheet that is visible? Sorry, new to excel and just a tad confusing at first.
sorry I think I have written this comment to totally wrong entry.
You can use a conditional formatting in the first place. so whenever the cell changes Excel automatically formats the cell color.
If you want to include it in the macro so that whenever you change the cell value, InteriorColor property can be used.