SOLVED

Highlight Blank Cells Only In Rows That Contain Data

Copper Contributor

Hello, we track certain information and my employees sometimes forget/miss filling in some cells. Is there a way that if they start typing in a certain row, any cell that is left blank will turn a color until it is filled in? I have figured out how to highlight blank cells, but it is highlighting all blank cells after the data as well and is making our tracking sheet look sloppy. I'm hoping to figure out how to only highligh

3 Replies
best response confirmed by HansVogelaar (MVP)
Solution

Hi @bramsburg 

 

Sample.png

 

with above sample, Cond. Format. rule (Use a formula...) that applies to $A$2:$F$5:

=AND(COUNTA($A2:$F2), ISBLANK(A2))

 

 

@Lorenzo You are the best! I'm not sure how it works, but it's working perfectly! Thank you so much!

@bramsburg 

Glad this helps. If this can help you understand the following does the same thing:

=AND(COUNTA($A2:$F2) > 0, ISBLANK(A2))

 

(At the bottom of each reply you get here there's a way to mark solution - helps those who Search... Thanks)

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

Hi @bramsburg 

 

Sample.png

 

with above sample, Cond. Format. rule (Use a formula...) that applies to $A$2:$F$5:

=AND(COUNTA($A2:$F2), ISBLANK(A2))

 

 

View solution in original post