View Single Post
  #1   Report Post  
Sam via OfficeKB.com
 
Posts: n/a
Default Conditional Format - Formula to Colour Every 3rd Cell in Offset Range

Hi All,

I require a Conditional Format Formula to Highlight every 3rd Cell in Red
that is Offset one column to the Right of the Dynamic Range called POSITION -
starting from Row19. Also, is it possible for the Formula to return the
number 3 in the highlighted Red Cells?

Thanks
Sam


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1