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 That would be:
=IF(G9="yes",C9,"")
meaning as much as, "If condition is met then value if true, otherwise value if false"
Riny_van_Eekelen Great thanks.