Hi All,
Am attaching a sample workbook. I want to do conditional formatting in this like, If measures in Worksheet1 is 60% or more then measures in Worksheet1 should get colored in blue(goal's color).
Similarly, if measures in worksheet2 is 30% or more then measures in Worksheet2 should get colored in orange.
Please help!!
3 answers
Hi @Twinkle Bansal
Drag measure values to color , click on color , then click on advanced.
Start will be 0 and end will be 1
Center for worksheet 1 will be 0.6 and for worksheet 2 it will be 0.3.
You can reverse and change the colors as required.
This should provide the attached result.
Regards
Antonio
