Conditional formatting with different rules from different columns applied to same column

[DianneB]

Hi, 

I have the following table set up.  I want to set up conditional formatting that highlights cell values based on the following criteria.

If Sales A is greater than or equal to 5 highlight blue. 

If Sales B is greater than or equal to 10 highlight blue.

That's simple for me to do BUT here is my problem.

If Sales A is greater than or equal to 5, Sales B automatically highlighted blue regardless of value against Sales B.

If there is no value against Sales A, then the conditional formatting for Sales B (that is, if greater than or equal to 10 highlight blue) applies.

If the sum of Sales A and Sales B is greater than 12 highlight both Sales A and Sales B blue regardless of other formatting conditions.

Hope this makes sense.

Site	Sales A	Sales B
Strawberry Fields	64	7
Mango Orchard	4	7
Vegie Patch	3	9

[DianneB · Accepted solution]

Wonderful - now are you able to tell me how I combine the two formulas into one DAX measure please.

[v-kkf-msft]

Hi @DianneB ,

Please try these measures.

Color_A = 
var _a = SUM('Table'[Sales A])
var _b = SUM('Table'[Sales B])
return IF(_a + _b <= 12 && _a < 5, BLANK(), "blue")

Color_B = 
var _a = SUM('Table'[Sales A])
var _b = SUM('Table'[Sales B])
return IF(_a + _b <= 12 && _a < 5 && _b < 10, BLANK(), "blue")

Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DianneB]

I have another question please - I have worked out the formula with your help but now want to use the same criteria to highlight costs but when I do so, blank cells will highlight because whilst the criteria will apply and only highlight cells which meet the criteria when I use as described, when I apply to something else even all cells highlight even if blank. Does this make sense?