How to selectively color fill in cells including headers. example : Profit in green , Quantity in Red , Sales in Yellow.
Measure values cells can be done by using separate legends but Headers are not filled in color. Format tool does not color correct header columns
Region |
Profit |
Quantity |
Sales |
Central |
39,706 |
8,780 |
501,240 |
East |
91,523 |
10,618 |
678,781 |
South |
46,749 |
6,209 |
391,722 |
West |
108,418 |
12,266 |
725,458 | |