One way:
in the cells you want to change conditional formatformula
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