Color conditional in vba for columns

Hello,

I'm trying to make a macro for each week column.

Column A are the unique codes and for each code there are two data of sales and fcst

cond. excel.xlsxcond. excel.xlsx
with the following conditional:

1. If we do not have Sales but we do have Fcst, both are red > If in the Sales cell = 0 and Fcst if it has data > Red
2. If we have Sales but it is below Fcst it turns both orange > Yes in the Sales cell > Fcst cell > Orange
3. If we have Sales and it is the same quantity as the Fcst, they both turn green
4. If we have Sales and the Fcst is less than this or is 0, both are turned purple.

Thank you.