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.
Bookmarks