Conditional formatting

Closed
bedunem Posts 1 Registration date Friday April 10, 2015 Status Member Last seen April 10, 2015 - Apr 10, 2015 at 01:11 PM
Hi,

I have a problem regarding a sheet i'm trying to format.
I want to color an entire row but i get color only in certain cells.
The sheet looks like this:

201401 201402 201403 201404
201401 10 10
201401 na 20 20
201401 10 na na
201402 na 20 20
201402 20 na na
201402 20 20 20
201402 na na na
201403 30 na na
201403 na na 30
201404 na na na
201404 40 40 40
201404 na na na 33

the range of the table is A2:E13

The formula I entered using conditional formatting is: =AND($A2=B$1,B2<>"na")
and the range : !$A$2:$E$13

Hope you can help...

10x

Bedenem