dek
09-15-2010, 06:30 PM
Hi,
I would like to allocate a cell colour based on the value of each cell over the entire sheet.
For instance, if the cell has the value 1 (a formula 1 result), the color is yellow (RGB code to be used)
If the cell has a value of 2, the color is blue (RGB code to be used).
I have tried VBA, but lucked out.
Assistance appreciated.
I would like to allocate a cell colour based on the value of each cell over the entire sheet.
For instance, if the cell has the value 1 (a formula 1 result), the color is yellow (RGB code to be used)
If the cell has a value of 2, the color is blue (RGB code to be used).
I have tried VBA, but lucked out.
Assistance appreciated.