For multiple cells in a fairly large spreadsheet, I would like to use conditional formatting (e.g. apply a red highlighted background) if the cell itself is equal to any of about 20 potential words (examples of these words are "unknown" or "N/A" or "not computed" or "score not calculated" or "Not reported", etc.). I would want the conditional statement to say something like, "If cell is equal to = "unknown" or "N/A" or "not computed" or "not reported" then turn cell red.
This is a data entry page that my data entry staff will be entering data into based on preset dropdown lists that I've already set. I just want to the file to automatically highlight in red the cells in which my data entry staff entered the specific words listed above, so that I can quickly scan the document and discuss the "red" cells with my data entry staff.
Bookmarks