Excel formula help please

[Mark M]

I have 6 months of data - Aug to Feb and what I want to identify is the rows that have a figure in Aug but nothing in the more recent months.

To give an example

            Aug   Sep    Oct    Nov   Dec    Jan   Feb
A          100      0       0     0      0     0     0
B          150      0       0     0      0   100     0
C            0    100       0     0      0     0    50

What I need is a way to highlight A and not B or C. My head is going to explode Ive tried all sorts of nested IF's and &'s but to no avail!!

Hopefully someone can come up with something!!!

Thanks

 

[Mark M]

Tried that and just a basic sort but you can only do upto 3 options and I need 6, possibly more in the future.

 

[Mark M]

Not fussed about it being clumsy at this stage, as wonko says it can easily be hidden!!

Many thanks guys, my brain can breath a sigh of relief now!!