View Single Post
  #6   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 i

I used the coding from your first example and that works; however....

I also have a conditional format on all the rows to highlight every other
row. The coding for that is: =MOD(ROW(),2)

The problem is that the coding to highlight the active cell's row does NOT
overcome the conditional format highlight. It does work on the rows without
the conditionally formatted highlight.

Is there a way to make this "highlight the active cell's row" code highlight
the rows that also have the conditional formatted highlight?