Conditional format if value entered without dates

[NS4Excel]

I have a start date and an end date field. Next I have the months of a year. I need a conditional format formula that says if there is no start date and or no end date but there is a number in one of the months, then that cell should be highlighted.

The formula I wrote is =AND(OR($AM17="",$AN17=""),AZ17<>””) but it's not working.

Thanks

[FDibbins]

How is the start/end date entered in the cell - manually or by formula?

[NS4Excel]

The dates would be manually entered. Then hours would be entered by month. I want to highlight any cell that contains hours if a start date and/or an end date is missing.

[FDibbins]

You made no mention of Hours in your 1st post?

Could you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like (see yellow banner above).

[NS4Excel]

Sorry, I wrote" but there is a number in one of the months...
I'll create a dummy file and get it uploaded. I can't share the actual file.

[NS4Excel]

Not sure if the attachment will come through.

[FDibbins]

Thanks, will take a look

[bebo021999]

With this:
=AND(OR($AM17="",$AN17=""),AZ17<>””)
try to replace with:
=AND(OR($AM17="",$AN17=""),AZ17<>"")
then it works for me.

[FDibbins]

aahh I see the difference now. I retyped the formula and it worked, but couldnt see why OP's version wasnt working. Didnt notice the Word ""...Thanks Quang