View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JesiR
 
Posts: n/a
Default How do I autofill conditional formatting?

I need to format twenty rows highlighting the max and min of each row, and
the only way I can find to do it is to do each row separately -- if I try to
do it for the entire thing, it either won't do it for rows or will highlight
the same numbers from the previous one. Is there a way to autofill this, or
is there some variable I should put instead of the row number? Please help
-- it takes forever otherwise!