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

"John Clark" <John (E-Mail Removed)> wrote in message
news:5FBF7146-27F2-40AC-9D04-(E-Mail Removed)...
> 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.