I want a formula to return the the text string "new" if another cell in the
same row has red colored text. How do I do this?