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?
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.
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
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With