Conditional formatting based on other column

[Anonymous]

I have a utilization table and I have to conditionally format each value based on the following matrix

Title	Target Utlization
Principal	50%
Director	50%
Manager	50%
Consultant	88%
Senior Consultant	88%

And my table looks like this;

Title	Utilization %
Consultant	82.47%
Consultant	82.10%
Director	20.74%
Director	19.31%
Manager	32.86%
Manager	28.05%
Principal	61.64%
Principal	29.62%
Senior Consultant	38.65%
Senior Consultant	37.50%

Please help 

[rubinboer · Accepted solution]

i agree more info is needed so i will make a few assumptions.

the two tables are linked by title and the title in the target table is unique.

creat a check to see if the utilization achieves the target,

Target Check =

VAR Target = LOOKUPVALUE('Tab A'[Target Utlization],'Tab A'[Title ],CALCULATE(MINX('Tab B','Tab B'[Title])))

VAR Base = SUMX('Tab B',[Utilization %])

return (Base - Target)

if his is negative you didntmake target if positive you made it

now create a conditional format rule on the table you wish to check, based on the Target check.

model

result

[TomMartens]

Hey @Anonymous ,

please provide more information what you exactly want to happen, and how the values from your table should be formatted based on what condition.

There are three states, less than, equal to, or greater than.

Another question, is there an existing relationship between both tables in your data model?

Regards,

Tom