Ask Your Question

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

asked 2018-05-02 20:01:52 +0100

bengineer gravatar image

updated 2018-05-02 20:43:51 +0100

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 See images below.

image description

Fig. 1. The cells in question.

image description

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-05-04 18:26:57.416634


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

Lupp gravatar imageLupp ( 2018-05-03 10:37:06 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-05-02 20:23:39 +0100

erAck gravatar image

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.

edit flag offensive delete link more


That solved it. Thanks!

bengineer gravatar imagebengineer ( 2018-05-02 20:44:12 +0100 )edit

Question Tools

1 follower


Asked: 2018-05-02 20:01:52 +0100

Seen: 398 times

Last updated: May 02 '18