How can I set up conditional formatting to highlight a range only if all its cells are empty?
- by Jennifer
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.