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...
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.
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.