Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Format entire row if a particular cell in the row is not empty

I want to format the whole row depending on if a particular cell in that is empty or not. I want conditional formatting to go through all rows and say add a background color if column C in that row is not empty.

How do I fix this?

like image 921
user3378720 Avatar asked Mar 04 '14 11:03

user3378720


People also ask

How do you conditional format a row if a cell is not blank?

The easiest way to highlight rows with non-blank cells is using Format only cells that contain rule from the New Formatting Rule window of Conditional Formatting. First, select your dataset and go to Home > Conditional Formatting > New Rule. Now, the New Formatting Rule window will be opened.


1 Answers

For illustration assuming "whole row" is ColumnsA:Z inclusive, please try Format - Conditional formatting..., Custom formula is:

=$C1<>""   

with formatting of your choice and Range: A:Z.

like image 117
pnuts Avatar answered Sep 25 '22 01:09

pnuts