Conditional formatting

Closed
Report
Posts
1
Registration date
Friday April 10, 2015
Status
Member
Last seen
April 10, 2015
-
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