Excel. Conditional Formatting issue.

I need to know if there's a way in Excel to have only 3 colors for the "Conditional Formatting" > "3-Color Scale"
to be NOT a "Graded Color Scale".
I only need RED, YELLOW and GREEN, if values fall in between of R and Y, then they come as Orange (Graded Scale effect).
Screen shot with Conditional Formatting
Mich MichBI LeadAsked:
Who is Participating?
 
Ryan ChongCommented:
Don't use Color Scales, use Highlight Cell Rules instead and follow the wizard.

snap.jpg
1
 
Martin LissOlder than dirtCommented:
Have 3 separate rules, one for each color.
1
 
Martin LissOlder than dirtCommented:
Something like this.
2018-02-26_15-37-09.png
1
 
Martin LissOlder than dirtCommented:
That's what my picture shows.
0
 
Mich MichBI LeadAuthor Commented:
Thank you, it works now.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.