Conditional Formatting - Combining 2 conditions

Hello,

I have three columns:

Column A: Start Date
Column B: End Date
Column C: Yes/No

I would like the cells in Column A to highlight red if a) The date falls before today, and b) the cell in Column C reads 'No'.

I can't seem to get the formula working for either condition. Any ideas?

Thanks

Of course, here you go

hi ,

which date would you like to check " The date falls before today "

Punnam

Lokesh Kumar, thank you!

There's also one more thing I'd like to do - I would like an IF statement in Column D which tells me if a project is delayed.

So in other words, the cell would read 'Delayed' if the start date falls before 'today' and and is not initiated, and 'On Track' if not.

Thank you!

Sorry LokeshKumar - one more thing, if it's possible.

I now have the following formula:

=IF(AND(A1<TODAY(),C3="No"),"Delayed","On Track")

... Which works perfectly for me. However I would like to add one more condition - that if the date in Column A is in the future, then the formula produces a 'Future Project' output.

Is this possible? I've tried tinkering with nested IF functions using the above formula, but can't get it working.

Hai shaunguyver

try this

=IF(A1>TODAY(),"Future Project",IF(AND(A1<TODAY(),C3="No"),"Delayed","On Track"))

That has worked like a charm. Thank you so much for all of your efforts :-)