Brain Not working with conditional formating

[damian_r_Home]

Howdo.
Yes this should be simple but as somebody only once in a blue moon has to now create spreadsheets, I can't figure out what to do and so your help is appreciated with the formulas

Cell G4 either has a date in it or is empty.
If empty, no conditional formatting should occur whatsoever.

If G4 contains a date, the following needs to apply.
If the value in cell I4 EQUALS 100 then no conditional formatting should apply
If the date is within the next 14 days of =TODAY(), then the cell should have an amber background
If the date is before =TODAY() and a value in I4 is less than 100, the cell needs to format red background


I think that's all i need, I just cant remember how to get an IF statement to work in the conditional formatting options

 

[Fluff]

How about
=AND(G4<>"",I4<100,G4<TODAY())
=AND(G4<>"",I4<100,G4<TODAY()+14)

 

[etaf]

you need a few rules and AND/OR statements rather than an IF

= AND( G4 <> "", I4 <> 100, G4 > = today () , G4 < = today() +14 )
thats should give amber

RED
= AND( G4 <> "", I4 < 100, G4 < = today() )

 

[damian_r_Home]

Thanks folks, I'll try them in a few short minutes.