PDA

View Full Version : Conditional Formatting



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.

dek
09-15-2010, 06:30 PM
Also, the conditional formatting tool in Excel is limited for my use. I would like a VBA solution.