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!
|