If text is of specific formt change another column colour to grey and add text in another

Hallo again,

I need to do the following in MS Excel 2013

If text in columns Z-AL is black bold underlined or grey italics, change cell in columns AN and AO dark grey.
and
If the text is black bold underlined or grey italics, then add "NO" in column AM

However, if the text in columns Z-AL is normal text, then add "YES" in column AM

I am attaching and example of the workbook. Sheet 1 contains an extract of the original and sheet 2 an example of the expected outcome.