Conditional Formatting with Multiple Rules (including Text & Merged Cells...eek!)

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

Thanks so much for your help! I finally was able to get it to work.

Appreciate it.

If you get bored, I posted a new problem. Ha!
http://www.excelforum.com/excel-gene...ml#post4228755