Forum Discussion

Gerry Garcia's avatar
Gerry Garcia
Copper Contributor
May 05, 2017

Formatt Cell

Hello,

   I would like to be able to put an "x" into a cell and have another cell showed "PAID" in green.

Thanks.

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hello Gerry

     

    Assuming you want to put an "x" in C5 and show "PAID" in H5.

     

    Format H5 with font color green and put this formula in H5:

    =IF(C5="x","PAID","")

     

Resources