Ask Your Question

Revision history [back]

As formatting condition choose "Cell value is", "equal to", and into the edit field enter "Awaiting" including the double quotation marks, and choose or create a style to your liking that is applied. If you want other cells with the string "awaiting" not formatted as shown in rows 4 and 6 you'll have to combine with a second condition that contains the same rules as used to format the dates in column E red, e.g. "between" or "greater than" with dates, or a formula that compares the date of the cell against some other data, you didn't specify what you want there.