Originally Posted by Gord Dibben

Teddy

Select A1 and FormatCFFormula is =A2=100

Format to a color under FormatPatterns and OK.


Gord Dibben Excel MVP

On Tue, 13 Sep 2005 14:31:47 +0100, TeddyTash
wrote:


Is it possible to do the following:

I want to make a cell change color depending on the value of a
different cell.

So for example if A2 = "100" then I want cell A1 to change color.

Please help!