Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 5th 05, 05:19 PM
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.

  #2   Report Post  
Old February 5th 05, 05:21 PM
JulieD
 
Posts: n/a
Default

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 wrote in message
...
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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I fill row colors based on cell value? Daskeeper Excel Discussion (Misc queries) 1 January 31st 05 10:12 AM
Excel change SUM references if you cut & paste the first cell in SUM... Marie J-son Excel Discussion (Misc queries) 5 January 30th 05 01:00 PM
Can Comments be automatically converted to text cell values? tomdog61 Excel Discussion (Misc queries) 1 January 23rd 05 09:38 PM
In excel, can I format a cell to automatically take the curser to. 1google Excel Worksheet Functions 2 January 14th 05 06:07 PM
Modify Row & Cell Contents based upon Cells Values bpat1434 Excel Worksheet Functions 1 November 6th 04 05:17 PM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017