You can use dual axis where you can apply color condition individually.
I use superstore as example shown below
I attached the workbook for your reference. If you could provide a sample workbook would be better.
Hope this could help you
color coding moving avg.twbx 1.2 MB