I want cell 'G4' to show "Red" if the value Cell 'D4' is greater than the
value of 'A7' and 'E4' is greater than 'A9' and show "Green" if any one of
them is less than 'A7' or 'A9' respectively.
I tried a formula but it didn't work as I expected.
=IF(AND(D4$A$7,E4$A$9),"Red","Green")
Any suggestions would be appreciated.

Thanks..
--
Karthi