View Single Post
  #1   Report Post  
John Clark
 
Posts: n/a
Default Can an excel cell automatically change fill colors based on values

I'm developing a customer satisfaction index. My question is: Can the fill
color of a cell automatically change to a pre-determined color based on the
cells value.

Example: If the cells value shows an average of 3.5 or greater the cell
fill color would be green.

Thanks for your help. I look forward to your response.