Pattern Formula?

I'm OK with understanding conditional formatting but my question is for
adjacent cells. What I need to do is to enter a conditional value in one cell
(in my case a "Y") and then have adjacent cells change their color pattern
(in this case "black").

Can this be done somehow?

Thanks
--
6-West

yes
in the first dropdown of the conditional formatting box, change the default
value from 'cell value is' to 'formula is'.. Then input a formula that
evaluates to T/f (like: $A1=1)

That should do it!

"sixwest" wrote:

> I'm OK with understanding conditional formatting but my question is for
> adjacent cells. What I need to do is to enter a conditional value in one cell
> (in my case a "Y") and then have adjacent cells change their color pattern
> (in this case "black").
>
> Can this be done somehow?
>
> Thanks
> --
> 6-West

Use the same criteria in the other cells but referencing the first. eg if A1
needs to be between 1 & 2 to fulfil the criteria, the in eg B1 use formula
is =if(A1>=1,A1<=2).

--
Ian
--
"sixwest" <sixwest190@yahoo.com> wrote in message
news:B848FC26-B219-4823-AB4C-98239DABC3D8@microsoft.com...
> I'm OK with understanding conditional formatting but my question is for
> adjacent cells. What I need to do is to enter a conditional value in one
> cell
> (in my case a "Y") and then have adjacent cells change their color pattern
> (in this case "black").
>
> Can this be done somehow?
>
> Thanks
> --
> 6-West

One way:
in the cells you want to change conditional format>formula
is>=if(a1?=y,true,false)

hth

"sixwest" wrote:

> I'm OK with understanding conditional formatting but my question is for
> adjacent cells. What I need to do is to enter a conditional value in one cell
> (in my case a "Y") and then have adjacent cells change their color pattern
> (in this case "black").
>
> Can this be done somehow?
>
> Thanks
> --
> 6-West