Forum Discussion
Gerry Garcia
May 05, 2017Copper Contributor
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.
- Gerry GarciaCopper ContributorThank You Sir!
- Detlef_LewinSilver 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","")