How to Set Condition Formatting on Columns on Stacked Column Chart

My work like I have 4 columns, first is DateTime (every hour 2023-8-17 00:00, 2023-08-17 01:00...), second is Silo No. (silo1, silo2,...), third is Quantity (ton) of product produced in each silo each hour, fourth is Quality (%) each hour each silo. when plot in stacked bar chart x-axis-->Silo No., y-axis-->Quantity (ton), legend-->DateTime, tootip--> Quality. I need to set condition format for each column in case quality 0%-50% Red, 51%-75% Yellow, >75% Green. something like this. the problem i found limitation of legend only 60 items and cannot set the condition format of columns.