UKC

I have a plea for help to the UKC excel gods.

I've got a table which is a review of several different files. In amongst the other information are several columns which have a yes or no (depending on whether something has been done). I want a format whereby as soon as all of the necessary checks are labelled as "yes" the row highlights so that I know to close it.

i.e

A B C D E F G H
1 - 123 mon hex Yes, No, Yes, Yes, Yes = No fill
2 - 456 tue cam Yes, Yes, No, Yes, Yes = No fill
3 - 789 wed nut Yes, Yes, Yes, Yes, Yes = Fill

I've tried =($D:$H="Yes")

but for some reason that only highlights the sections of the row which don't contain the yes/no (in the table above, it would highlight 3A:3C)

I've spent far more time on this than it's worth, but wondered if there was some kind soul who could point me in a better direction (or give me the formula )

Thanks in advance
Steve

In reply to I'd rather be climbing:

I hate conditional formatting, its approach to the formulas are a pain.
I would, if i went that route, probably add a new column (which can be hidden) with
countif(A1:a5,"Yes")=4 (swap range and total count as needed).
Then can either use that as a filter to hide from or point the conditional formatting at that eg (hiddencell=4).

In reply to I'd rather be climbing:

Do you want something along the lines of =COUNTIF($D1:$H1, "Yes")=5 ?

Then this might help:

http://www.howtogeek.com/howto/45670/how-to-highlight-a-row-in-excel-using-...

In reply to dissonance:

I'll give that a whirl, thanks.