Forum Discussion
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.
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","")