Showing above and below target comparing values

[Anonymous]

Hi community,

I have a table visual in a report I am working on showing target values and actual values for different categories and locations. So for the target table where I have the data for targets per location and category I have: 

Location	Category	Lines	Target
Sweden	Drilling	1	2
Sweden	Milling	2	2
Sweden	Turning	2	6
Denmark	Drilling	2	4
Denmark	Milling	1	1
Denmark	Turning	2	6

And from a database I get the actual figures as in this example:

Location	Category	Month	Actual
Sweden	Drilling	aug	2
Sweden	Milling	aug	8
Sweden	Turning	aug	11
Denmark	Drilling	aug	4
Denmark	Milling	sep	7

So the database will keep building of course with more data for every month. I get the data in the visual table all well but when I filter per month I want the "actual" column in the visual to turn red if above target and green if below or equal to target. The resulting table should look like this when filtered:

Location	Category	month	Target	Actual
Sweden	Drilling	aug	2	2
Sweden	Milling	aug	2	8
Sweden	Turning	aug	6	11
Denmark	Drilling	aug	4	4

So the numbers are all correct but how to make a "dynamic" calculation like this for, I am assuming, conditional formatting? I am stuck to how to achieve this and any help would be much appreciated.

Regards,

Maud