Conditional Formatting and an IF statement

[honeybee129]

I need to know if it's possible to make Excel use an IF statement to decide whether to apply conditional formatting to a cell. What I have is this:

If cell G2 is greater than or equal to .15 then cell D2 should have no conditional formatting applied to it, cell should have no fill.

If cell G2 is less than .15 then the following conditional formatting should be applied:
Condition 1: If cell D2 value is greater than or equal to 00:06:00 cell fill color should be green
Condition 2: If cell D2 value is less than 00:06:00 cell fill color should be red

 

[snekkis]

Drop the IF, you need something that generates a TRUE/FALSE value:

Try this:
=AND(AE2="Yes",OR(E2>TODAY(),F2<TODAY()))

That was it, thanks!