As the title says I'm wanting conditional formatting to be in use. Column K:K contains cells that are to be manually changed from blank to not-blank. When the cell is not blank I want to cell beside it, in Column L:L, to change text from "Due" to "Complete". Is this possible? I've managed to get it to change format of the cell via: =NOT(ISBLANK(K1) but I need to change the text within the cell, not the formatting, as other cells/formulae are reliant on it changing.
This question generated 13 answers. To proceed to the answers, click here.
This thread is current as of July 19, 2017.