View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jayceejay jayceejay is offline
external usenet poster
 
Posts: 24
Default Conditional formatting on ADJACENT Cells

I know this may sound like a dumb question, but I have values in column A
that I want to have a grey background if their corresponding value in Column
B =1. I can't seem to find a way to establish that condition for a cell
other than itself! HELP, Please??