Formula for a Flag Column Based an If/Or statement

pkburns

I'm trying to write a formula using an IF/OR statement to set a flag (for the Revised Timeline column) when NA has been selected from a drop-down menu in the any one of five columns (e.g., Reason for Revised Analysis End Date). The flag should turn red when anything other than NA is selected. If NA is selected, then no red flag. See the attached image.

Or, if it's easier, I could set the flag to turn red when the dates are changed in any of the five End Date columns.

 

reagan.cink

For row 1, type this formula in the "Revised Timeline" column (which should already have the symbol -> flag property:

 

=IF(OR([Printable Materials Identified]1 = "NA", [Tentative Timeline Created]1 = "NA", [Project Proposal Form Submitted]1 = "NA", [Project Proposal Form Approved]1 = "NA", [Reason for Revised Analysis End Date]1 = "NA"), 1,0)

 

Then use the drag-fill method to extend the formula down for all rows in the sheet.