Conditional Formatting for adjacent cells
 

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?
--
Drew

Conditional Formatting for adjacent cells
 

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

--
HTH

Bob Phillips

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

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