Conditional Formatting If..Or.. Then

Hello.

I'm currently using this formula: =OR($A2="",$E2="",$E2="mm/dd/yy")

Is there a way for me to do something like this:

If $A2="",$E2="",$E2="mm/dd/yy" then $F2= ""

and if that statement is false then $F2 = "y"

Thanks so much.

IN F2

=IF( OR($A2="",$E2="",$E2="mm/dd/yy") , "", "Y")

Hi etaf,

Thanks, but nothing is happening. I have attached my workbook

Oh whoops! Thank you!

did you put the formula into F2
OR is it a conditional format we are trying to set for F2

here your spreadsheet updated