Can an excel cell automatically change fill colors based on values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi John

yes, if you have three or less conditions use Format / Conditional
Formatting.

For more than three you can use VBA.

Please feel free to post back with the conditions and required results if
you would like more assistance.

Regards
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can RGB fill color be automated based on 3 cell values? 2
Dynamically setting CELL COLORS based on TWO OTHER cell values 4
Counting of cells with a specific color filled 9
Associating a fill color with a cell value 2
How to auto enable Excel, set cell color based on the numerical va 3
How to filter rows data based on background color of individual cells 1
Conditional Format a range based on 1 cell 1
Change cell fill color options 1

Back
Top