Conditionl Format

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!


--
TeddyTash

Teddy

Select A1 and Format>CF>Formula is =A2=100

Format to a color under Format>Patterns and OK.


Gord Dibben Excel MVP

On Tue, 13 Sep 2005 14:31:47 +0100, TeddyTash
<TeddyTash.1vb8nl@news.excelbanter.com> 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!