CF row C:K if H13 is a blank cell

[ExcelRoy]

Hi all,

I am looking for a formula to highlight rows C:K if column H is blank?

I have the following which partially works, not the whole range

=H13<>""

Any help appreciated

 

[Joe4]

Since you want EVERY column to look at the value in column H, you need to lock the column reference down like this:
=$H13<>""

So, if you select all the columns you want to apply it to first, and then enter the formula like I show above, it should work.

See here for more details: [/COLOR]http://www.cpearson.com/excel/relative.aspx

 

[JoeMo]

Also, if you want the highlight when the col H value is BLANK, change the rule to:

=$H13=""

 

[Joe4]

Also, if you want the highlight when the col H value is BLANK, change the rule to:

=$H13=""

Good catch. I was so focused on the range reference, I didn't look close enough to verify the logic if the formula!

 

[ExcelRoy]

brilliant thanks guys

 

[JoeMo]

Good catch. I was so focused on the range reference, I didn't look close enough to verify the logic if the formula!

Proving, once again, that, sometimes two Joe's are better than one, and historically we know it works both ways!

 

[Joe4]

Proving, once again, that, sometimes two Joe's are better than one, and historically we know it works both ways!