
Hi All,
Attaching a sample workbook where I want to show sales if below 25000 then red else green and profit if below 0 then red else green.
Rest Quantity and discount should be displayed the way it is in single sheet.
Please help.
Thanks
2 answers
Hello,
The conditional formatting will apply on entire row.
So if I apply the color formatting on sales it will automatically apply to other measures in that row.
IF you want workaround for this,
take ifferent sheet for different measures and on dashboard you can arrange it to one next other.
Hope this work
Regards
Jaideep