View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Conditional Formatting various colums at once

Select C1, D1 and F1 and use a formula of

=$A1$B1

--
__________________________________
HTH

Bob

"Compare Values" wrote in message
...
Hi, I would like to add a Conditional Formatting to various colums at
once.
Example if A1B1 make cells C1, D1 and F1 red,
Please advise