Conditional Formatting not working
source link: https://answers.sap.com/questions/13890250/conditional-formatting-not-working.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
I have a scenario where we have to show the quantities coming from status Planned as "Yellow" color and Produced as "Brown" color.
I have the status column which is bringing these 2 lots and because of this i am getting 2 rows for a common ID. For example
ID1 Produced 10 (brown color) Date--April 2020(header of crosstab)
ID1 Planned 18 (yellow color) Date--April 2020 (header of crosstab)
expectation:
ID1 Date--April 2020(header of crosstab) 10 and 18 (in a single row) with 10 highlighted as brown and 18 with yellow.
The business wants this in single line and to remove the duplicates.
Note : the Status column is hidden
tried deleting the status column then the formatting is not working
Please advise the solution.
Thanks
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK