View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Terri Terri is offline
external usenet poster
 
Posts: 110
Default Conditionally format

Hello,
How can I ( in code) conditionally format columns B thru H (to last row in
columns) to be "No Fill Color" if the cells directly on the left and right on
the same row are populated? Example: If A1 and C1 are populated, the B1 would
have "No Fill".
Thank You for Your Help,
Terri