Thank you for your response but the only problem is that I already have 0 and 1 in the data sheet, I want it to change if someone changes the value.
If I use the above all 0 will be read and all 1s will be orange even if they are not changed.
I only want the cell to be coloured if the...
Hi, Very simple problem,
I need to track changes by changing cell colour. If the value of a cell is changed from its current value to either 0 or 1. I want the cells to be hilighted in red or orange.
- Cell values will be input manually in each cell.
- values will be either 0 or 1...