[Solved] [Calc] Conditional formatting - based on cell's empty/filled status

[bengineer]

Hi, I am trying to figure out how to auto-format a cell based on whether or not another cell is filled or empty, and have not been able to find anything in the Conditional Formatting dialog box (LibO 5.3.4.2). See images below.

Fig. 1. The cells in question.

Fig. 2. Drop down menu for “Conditional Formatting” > “Condition”.

Specifically, I want the text displayed in column C to read “Yes” IF its neighbor in column D has a date entered (that is, the cell is filled, as opposed to empty), and “No” IF its neighbor is empty.

I appreciate the help.

[Lupp]

You should also understand that CF for one cell based on conditions concerning (referencing) different cells requires to select the ‘Formula is’ mode.

[erAck]

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.

[bengineer]

That solved it. Thanks!