Microsoft Office Forums Conditional Formatting with Graded Color Scale

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-25-2013, 07:29 AM
Texas_Steve Texas_Steve is offline Conditional Formatting with Graded Color Scale Windows 7 64bit Conditional Formatting with Graded Color Scale Office 2010 64bit
Novice
Conditional Formatting with Graded Color Scale
 
Join Date: Sep 2013
Posts: 3
Texas_Steve is on a distinguished road
Question Conditional Formatting with Graded Color Scale

I need to use multiple rules with conditional formatting. But when I use the graded color scale, it only uses the first rule and ignores the rest. Am I doing something wrong? I have attached the test spreadsheet I am using. Note that the second rule seems to be ignored. Thanks.
Attached Files
File Type: xlsx Format_test.xlsx (16.7 KB, 6 views)
Reply With Quote
  #2  
Old 09-25-2013, 09:23 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional Formatting with Graded Color Scale Windows 7 64bit Conditional Formatting with Graded Color Scale Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Can two different scales be applied to the same range?
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 09-25-2013, 10:05 AM
Texas_Steve Texas_Steve is offline Conditional Formatting with Graded Color Scale Windows 7 64bit Conditional Formatting with Graded Color Scale Office 2010 64bit
Novice
Conditional Formatting with Graded Color Scale
 
Join Date: Sep 2013
Posts: 3
Texas_Steve is on a distinguished road
Default

I do not know. I use a different range for each of the rules, but it ignores the second.
Reply With Quote
  #4  
Old 09-25-2013, 10:07 AM
Texas_Steve Texas_Steve is offline Conditional Formatting with Graded Color Scale Windows 7 64bit Conditional Formatting with Graded Color Scale Office 2010 64bit
Novice
Conditional Formatting with Graded Color Scale
 
Join Date: Sep 2013
Posts: 3
Texas_Steve is on a distinguished road
Default

I just realized you meant the same row/column range. Hmmm...Once again I am not sure. But, if I use the option to simply color a cell a specific color based on value, multiple rules do work.
Reply With Quote
  #5  
Old 09-25-2013, 11:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional Formatting with Graded Color Scale Windows 7 64bit Conditional Formatting with Graded Color Scale Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

As far as I understand it the scale formatting will format from red to blue from lowest to highest value. I don't think you can use various scales that way.
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting with Graded Color Scale Conditional color fill based on presence of data avanderh Excel 11 07-28-2011 09:10 AM
Conditional Formatting with Graded Color Scale How to choose scale effect for Formatting Palette? schwine Excel 1 04-09-2011 11:23 PM
How to choose scale effect for Formatting Palette? schwine Word 0 04-02-2011 09:11 AM
help with formatting my project, particular to issues of scale oompa_l Project 0 11-17-2010 01:10 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM


All times are GMT -7. The time now is 03:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft