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).
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).
Martin Liss
Have 3 separate rules, one for each color.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's what my picture shows.
ASKER
Thank you, it works now.