View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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