Forum Discussion
Formatting one cell based on the content of multiple other cells
I am trying to format a document to auto fill based on the content of 3 other cells for example; if D9, E9 and F9 (using dropdown list) are all equal to "yes" G9 will auto populate to "yes", B...
Jim_Martin Try this:
=IF(COUNTIF(D9:F9,"yes")=3,"yes",IF(COUNTIF(D9:F9,"no")<>0,"no",IF(COUNTIF(D9:F9,"In Progress")<>0,"In Progress", "-")))Not very elegant, but it works. Note that your screenshot suggest that when both No and In Progress occur, that No should be the end result.
Riny_van_Eekelen Thanks for your help, that works like a charm.