Conditional Formatting for adjacent cells

[Guest]

Hello,

I am trying to setup conditional formatting for some adjacent cells in my
worksheet. For example is it possible to apply conditional formatting to
cell B2 when cell A2 meets the criteria you are looking for?

 

[Bob Phillips]

Yes, refer to A2 column absolutely, that is $A2

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)