COUNTIF for 2 columns, conditional-formatting an entire row - THANKS!

[martlume]

Hi,

I am trying to count the rows where COLUMN B = NAME and COLUMN C = "YES". Please see the source data as the first image and desired outcome as the second image.

Secondly, is there a way to use conditional formatting on the entire row based on one cell in that row?

Any help would be greatly appreciated!

Cheers,
Mart

[duane]

=SUMPRODUCT((B1:B100="name")*(C1:C100="yes"))

extend range as necessary

for the conditional formatting just set up a forula in the conditional formatting box such as

=$A$11=1

and then copy the formatting of the cell across the entire row

[davesexcel]

Check out this site on sumproduct very descriptive


http://www.xldynamic.com/source/xld.SUMPRODUCT.html

[martlume]

Hi,

Thanks! SUMPRODUCT link educated me a lot and the proposed solution also worked! Awesome!

As far as the conditional formatting question goes, I would like to copy this condition (the condition being "make entire row gray if cell in column B is blank") down 400 rows, so I assume there is no decent solution to this.

Thanks again!
Mart

[davesexcel]

Please Login or Register  to view this content.

here is a code it searches column B and if the cell is blank, it gets colored grey