Help with conditional formatting

[ExcelGuruWannaBe]

I am trying to create a spreadsheet with 3 conditional formats:
1) Cell Value is less than =$D$6+(((($D6*$AE$6)/$H$2)*Y$3)*$AE$7); format = Red
2) Cell Value is less than =$D$6+(((($D6*$AE$6)/$H$2)*Y$3)*$AE$9); format = Yellow
3) Cell Value is greater than or equal to =$D$6+(((($D6*$AE$6)/$H$2)*Y$3)*$AE$9); format = Green

Everything works find unless there is nothing input into the cell and then it formats red. I tried the Formula Is/And function, but thas does not seem to work for me either.

Any thougts? Thanks!

 

[AlphaFrog]

Try this...

Condition 1:
Formula is =AND(A6<>"",A6<$D$6+$D6*$AE$6/$H$2*Y$3*$AE$7)
Red

Condition 2:
Formula is =AND(A6<>"",A6<$D$6+$D6*$AE$6/$H$2*Y$3*$AE$9)
Yellow

Condition 3:
Formula is =AND(A6<>"",A6>=$D$6+$D6*$AE$6/$H$2*Y$3*$AE$9)
Green


In this example, cell A6 is the cell that has the Conditional Formatting.

 

[ExcelGuruWannaBe]

Thanks Alpha Frog -worked perfectly!!!