Skip to content

Cookie settings

Choose which kinds of cookies you allow. You can change your choice at any time via Cookie settings at the bottom of every page. Privacy statement

Necessary

Always on

Needed to log in, keep your cart and remember your choices. These are always on.

Which cookies?
  • weboke_sessie, weboke_klant, weboke_remember: your session and staying logged in
  • weboke_basket: your cart
  • wkBtwIncl: showing prices with or without VAT
  • wok_cookies: your cookie choice, 12 months

Measures which ad leads to a visit or order, so we do not pay for ads that do nothing.

Which cookies?
  • Google Ads via Google Tag Manager (_gcl_au, _gcl_aw), up to 90 days
  • OpenAI Ads, ads in ChatGPT
  • wok_aff: which partner referred you to us (affiliate programme), 60 days

4.6

Country and language

Each country has its own site, with prices and VAT for that country.

View

Icons and bars that show whether you hit your target

A production overview with a target for each product and what was actually sold: you want to see at a glance which products hit their target. With conditional formatting you add a green, yellow or red icon, or a bar that shows how far along you are. The catch: by default, icons compare the numbers with each other, not with your target. So you need to set the thresholds yourself.

As an example we'll use Bakkerij De Korenaar: column A holds the product, B the target for this month and C the number sold.

Step 1: a helper column with the percentage of the target

An icon can't directly "compare with the cell next to it". That's why you first calculate how far along you are. Type in D2:

=IF(B2=0,"",C2/B2)

fill the formula down and give column D the Percentage format. 1,265 sold against a target of 1,200 gives 105%. The IF prevents #DIV/0! when there is no target.

Step 2: a rule with icons and your own thresholds

  1. Select the percentages, D2:D7.
  2. On the Home tab, click Conditional formatting and choose New rule. (Under Icon sets in the same menu you can also pick a set directly, but then you get the default thresholds.)
  3. Under Rule, choose Icon sets. Under Icon style, choose the set, for example red, yellow and green.
  4. Each icon has a line with a comparison, a value and a type. For the green icon, set the type to Number and the value to 1 (100% of the target).
  5. For the yellow icon, set the type to Number and the value to 0.9. Everything below that turns red.
  6. Click OK.
The Conditional formatting menu
Conditional formatting with options including Data Bars, Icon sets and New rule
Setting the thresholds
Green from 1 (100%), yellow from 0.9, red below that; both with the type Number

Why set your own thresholds? By default the values are 67 and 33, with a type that looks at the other cells: the weakest product then always gets red, even if it comfortably hits its target. With the type Number and fixed values, you compare each product with its own target.

Now every product that hits its target gets green, anything between 90 and 100% gets yellow, and the rest gets red. In the same window you'll also find Reverse icons order (handy when lower is better, such as with complaints) and Show icon only, if you don't want to see the percentage itself. To make changes later, go to Conditional formatting, Manage rules, Edit.

Data bars

A bar in the cell shows how large a number is compared with the rest. For example, select the quantities sold, C2:C7, and choose Conditional formatting, Data Bars and a colour.

Icons and bars
Icons next to the percentage of the target and bars next to the quantities sold

Pitfalls

  • Icons on the numbers themselves instead of on the percentage: then you compare products with each other and not with their target. A product with a low target will then always be red.
  • Percent or Percentile as the type makes the threshold depend on the other cells. Choose Number for a fixed threshold.
  • Value and format: a cell that shows 93% contains 0.93. So compare with 0.9 and 1, not with 90 and 100.

One moment…

Set up your domains

For each domain, arrange the nameservers, the link to your hosting and who becomes the owner.

Loading your domains…