Sleeper: Conditional Formatting

[dek]

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]

Also, the conditional formatting tool in Excel is limited for my use. I would like a VBA solution.