conditional formatting to match non-blank cells with blank cells in a range

[miinstrel]

Hi everyone -

My project today has been figuring this formula out and... it's not going well :P

What I need is to use conditional formatting in cell A2 to accomplish the following:

"If for the range C2:H2 any cells are NOT blank, check cells C$1:H$1. If ANY of those corresponding cells in row 1 are blank, highlight cell A2 red."

I'm going to apply this formula in Column A for any customers added to the list (hence the $ in the C$1:H$1 reference). So cell A2 would NOT be highlighted because all quantities in cells C2:H2 have a corresponding lot number above. Cell A3 WOULD be highlighted because cell D3 does not have a corresponding number in cell D1. Does that make sense?

Also posted on ExcelForum.com: http://www.excelforum.com/excel-gen...on-a-cell-and-a-related-cell-being-blank.html

 

[miinstrel]

Solved on ExcelForum.com.

Formula is: =SUMIF(C$1:H$1,"",C2:H2)>0