colour interactive map based on data

What happens if, in your dataset, you put an error value for prefectures where there are no sales? For example, type the formula

Formula:

=NA()

I use this trick in charts where I don't want a data point plotted (Excel likes to evaluate a blank as a zero).