Howdy & Happy Sunday!

I am in an excel quandary and can use some help. I have reached that "throw something at the monitor" level of frustration.

I am trying to do conditional formatting for cells in the 23rd row (which is a formula of ?22-?21 where ?=column letter).

If the number is greater than zero and the project fee type (row 4) is Fixed Fee, then I want it to highlight as red. If the number is less than zero, then I want it to highlight green.

However for the fee type of Hourly, I want it to do the opposite where if it is greater than zero it should highlight green and highlight red if it is below zero.

I have tried to separate the formulas to try and follow the priority but had no luck. I also tried the AND function (=AND((C3="Fixed Free"),(C23>0)) but that did not work either.

I have been googling my face off with no results trying a bunch of things. Any help would be greatly appreciated!
Thanks!
Danieltest.xlsx