Ask Your Question

How to apply conditional formatting to a column

asked 2018-07-21 18:53:25 +0200

UnicornLynn gravatar image

I have a column that I want to have different background colors based on content or lack thereof. I can set it up, except that I don't see how to use the ISBLANK() formula in this context because I want each cell to look at itself to see whether it is empty. The only related answer I see uses a specific cell in the test--e.g., ISBLANK(F1)--but how do I get the cells in the column to look at themselves instead of some specified cell? I tried using ISBLANK() as the formula, but that didn't work for me. Specifically, I want the cells to be red if they're empty, and other colors based on content.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-07-21 21:58:12 +0200

kompilainenn gravatar image

Try use as different condition : value is - equal - "" in dialogue Conditional formatting for your range. And select cell style with red background for it.

edit flag offensive delete link more


Thanks--that works. I'm coming out of an Excel background, and testing an empty string doesn't always work there so I didn't think about it.

UnicornLynn gravatar imageUnicornLynn ( 2018-07-22 18:12:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-21 18:53:25 +0200

Seen: 112 times

Last updated: Jul 21 '18