Nested Formula not working with Conditional Formatting

Hi,

I have created simple conditional formatting based on if the formula in column A is >21 turn bold red text. I'm trying to add the additional Conditional Formatting in Column A to also meet three criteria shown below. I've attached an Example 1 workbook to see a snapshot of the file I'm working with. I feel like I'm close, but the formula isn't working at all.

Formula that doesn't work: =AND($C$2="Y", $B$2="N", $A$2 >14) to turn bold purple text if all three criteria are met

Hopefully someone can fill me in on where I'm going wrong.

Thanks!
kdestef1

Please Login or Register  to view this content.

Thank you both, Bernie Deitrick and BMV for your solution. Worked perfectly!! Thank you so much!