Conditional formatting based on multiple adjacent cells

[frumpy]

I have months as header rows in B1, C1, D1...and names of companies in column A. Whenever I receive an update from a company, I'll enter it in the appropriate month field, so a March update for company 3 will be pasted into cell d4 (March column, company 3 in row 4 given headers). If I don't hear from a company for 6 consecutive months, I'd like month 6 cell to conditionally format its background color so that I know it's been 6 months and I need to proactively contact that company.

I don't need the conditional to determine what the content is in any cells, simply Red fill if there's no text in the cell itself or in any of the 5 to its left, no fill if there's content in the cell itself or in any of the 5 to its left.

I'm struggling to make this work despite finding somewhat similar questions on the message boards. Thanks!

 

[Joe4]

Welcome to the Board!

So, your data actually starts in cell B2 (since row 1 and column A has headers). So the 6th month appears in column G.
So, highlight the range starting in cell G2 and go all the way over to your last column and all the way down to the last row, then apply this Conditional Formatting formula):

=countblank(a2:g2)=6

and then apply your formatting background color.

This should do what you want.

 

[frumpy]

Worked great. Thanks so much!!

Welcome to the Board!

So, your data actually starts in cell B2 (since row 1 and column A has headers). So the 6th month appears in column G.
So, highlight the range starting in cell G2 and go all the way over to your last column and all the way down to the last row, then apply this Conditional Formatting formula):

=countblank(a2:g2)=6

and then apply your formatting background color.

This should do what you want.

 

[Joe4]

You are welcome! Glad to help.