Forum Discussion
Jim_Martin
Jul 20, 2022Copper Contributor
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...
Riny_van_Eekelen
Jul 20, 2022Platinum Contributor
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.
Jim_Martin
Jul 21, 2022Copper Contributor
Riny_van_Eekelen, another quick question for you
On a lesser scale i want to then format another cell to show the contents of cell C9 if G9 is equal to "yes". i tried =IF(G9,"yes")=C9) but that's not right.
On a lesser scale i want to then format another cell to show the contents of cell C9 if G9 is equal to "yes". i tried =IF(G9,"yes")=C9) but that's not right.
- Riny_van_EekelenJul 21, 2022Platinum Contributor
Jim_Martin That would be:
=IF(G9="yes",C9,"")
meaning as much as, "If condition is met then value if true, otherwise value if false"
- Jim_MartinJul 21, 2022Copper ContributorRiny_van_Eekelen Great thanks.