Conditional Format Question

How can I conditionally format cell A1 when that conditional format is based
on another cells value? Example: I want to highlight A1 with Red when cell
B2= 2

format>conditional format>formula is
=b2=2
format as desired

--
Don Guillett
SalesAid Software
donaldb@281.com
"DougS" <DougS@discussions.microsoft.com> wrote in message
news:42AE7FC2-B5D0-4D2C-A4E2-9E748026C628@microsoft.com...
> How can I conditionally format cell A1 when that conditional format is
based
> on another cells value? Example: I want to highlight A1 with Red when
cell
> B2= 2

Doug

Select A1 and Format>CF>Formula is:

=$B$2=2

Pick a nice red color from the Format>Patterns Tab and OK your way out.


Gord Dibben Excel MVP

On Mon, 2 May 2005 17:15:16 -0700, "DougS" <DougS@discussions.microsoft.com>
wrote:

>How can I conditionally format cell A1 when that conditional format is based
>on another cells value? Example: I want to highlight A1 with Red when cell
>B2= 2

1) Click on A1
2) Open conditional formatting
3) Change the drop box from "Cell Value Is" to "Formula Is"
4) Enter "=B2=2" (without quotes) as the formula
5) Choose your format, pattern

HTH
Steve
"DougS" <DougS@discussions.microsoft.com> wrote in message
news:42AE7FC2-B5D0-4D2C-A4E2-9E748026C628@microsoft.com...
> How can I conditionally format cell A1 when that conditional format is
> based
> on another cells value? Example: I want to highlight A1 with Red when
> cell
> B2= 2