How can I set up conditional formatting to highlight a range only if all its cells are empty?
Posted
by
Jennifer
on Super User
See other posts from Super User
or by Jennifer
Published on 2012-06-06T18:48:50Z
Indexed on
2012/06/06
22:42 UTC
Read the original article
Hit count: 242
microsoft-excel
|conditional-formatting
I am new to conditional formatting and having a hard time. I have 6 columns with 100 rows. What I would like to have happen is to highlight the row in one color if there is no data in it at all. If there is data in one cell within the row, however, I would like for the highlighting to be removed from the row completely. Currently I have it set up to highlight the entire row if there is no data in it and if there is data in one cell, only that cell has no highlighting....I can't seem to make the entire row's highlighting disappear.
I have used the formula to determine which cells to format:
=I16:N16="" formatting color is yellow.
I know I have to add a second conditional format but I have tried numerous different formulas and cant seem to get it to work.
© Super User or respective owner