LinkBack URL
About LinkBacks
I can't seem to figure out why the color scale isn't working for some cells in this workbook. For instance, A7 should be red/orange and it is green.
I can't seem to figure out why the color scale isn't working for some cells in this workbook. For instance, A7 should be red/orange and it is green.
1. Include a sample workbook with an example of the result you want
2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.
Go to conditional formatting | manage rules and delete the various rules you have there for cells in that column. Next, click on the A to select the whole of the A column, then go to conditional formatting and select colour scales - select the green - amber - red icon. All done.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Maybe you have too many rules, change it to just column A
CondFormt.jpg
That seems to have done the trick! Any idea why excel gets confused with multiple of the same rule?
Thanks for the rep - glad to have helped! Not sure about Excel's confusion, but there's no good reason I can see for having more than one rule applied to the whole column. Employ the KISS principle!Originally Posted by k64
I assume the a color scale should interpolate a value/color based on relative position in the range of values
Attachment 866355
Conditional Formatting | Color Scales | Red - Yellow - Green Color Scale
Data range 11700 to 35600.
Two sets of numbers within that range
different color for the value 22635 depending on other vales in the range!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks