Ask Your Question

how to conditional format blank cells in excell

asked 2019-10-10 12:54:51 +0100

how to conditional format blank cells in excell

edit retag flag offensive close merge delete


Please ask Excel questions on an Excel Q&A site.

Opaque gravatar imageOpaque ( 2019-10-10 13:13:58 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-10-10 13:21:26 +0100

erAck gravatar image

Excel isn't relevant here, but in LibreOffice Calc on for example cell A1 you go to menu Format -> Conditional -> Condition, as Condition 1 select Formula is and in the edit field enter ISBLANK(A1) and for Apply Style choose or create a style. If the condition is to be applied to a cell range enter the range under Cell Range (or select the range before invoking the dialog).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-10 12:54:51 +0100

Seen: 20 times

Last updated: Oct 10