View Single Post
  #1   Report Post  
Fitz
 
Posts: n/a
Default Auto color-shading of rows

Can I automate an excel worksheet such that if ,say, "436" is written in a
certain cell it shades that row yellow, or if "437" is in that cell it
shades the row blue. It would then be easy to visually tell in an excel
chart which lines belonged to ,say, specific companies.