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" wrote in message
...
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