How to use and apply the COLOR SCALE rules in conditional formatting please follow the step shown below and example in image and video.
- GO To Home Tab.
- Then Go To Conditional Formatting.
- Under That Go To Color Scale.
- In That You Will Find Several Color Scale With Different Colors.
- You can choose according to your choice which make your database looks good.
- This Rules Work To Highlight The Data Sets To Find The Lowest To Highest Data Sets Within The Table Range By Different Color Scale.
- It Usually Used By Sales Company To Generate The Reports.