Thread: Conditional Formatting of Entire Row when the Active Cell is in ro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shannon Shannon is offline
external usenet poster
  
Posts: 53
Default Conditional Formatting of Entire Row when the Active Cell is in ro

I would like to highlight/shade the entire row that currently has the
active/selected cell. For example, whenever I am anywhere on row 10 I would
like all of row 10 to be highlighted or shaded a certain colour. I have been
looking for a function like ACTIVEROW or ACTIVECELL so that I can then use
conditional formatting, but can't find anything.

I am using EXCEL 2007.

Please help. Thanks.

Reply With QuoteReply With Quote