Ask Your Question

Revision history [back]

Wrong tool. Conditional formatting is for, well, cell formatting, not content. Use a formula instead, i.e. in C2 enter =IF(ISBLANK(D2);"No";"Yes") then pull down that formula to the desired end row. Or copy the cell, select the target range, and paste.