Sorry in advance I know this isn't the Google help forum, but I'm trying to learn after a lifetime of excel.
How would I format cell A2 to simply change colour based on the following:
A1 is not blank (=NOT(ISBLANK(A1)), A2 contains the text "yes" , A3 is Blank (=ISBLANK(A3))
I think that's the correct code I just cant work out how to string it together.
Bookmarks