Conditional formatting a field based on 5 variables

Question

Hi, I have been challanged with this one and hunted google etc to no avail and looking for some advice:&nbsp;I would like to colour code a name field based on 5 different cells: Thisis an abridged table to make life easy, but I have about 60 names or so...&nbsp;e.g.&nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp;Indicator 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Indicator 2&nbsp; &nbsp; &nbsp; &nbsp;Indicator 3&nbsp; &nbsp; &nbsp;Indicator 4Smith, John&nbsp; &nbsp; &nbsp;23/3/19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2Low, Tony&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Price, Toby&nbsp; &nbsp; &nbsp; &nbsp; 6/4/19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Walk, Janine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp;Where values are present, they represent compliance to a requirement. I would like 3 outcomes if possibleThere is 1 date field and the remainders are numerical fields based on measures.1. Highlight name Red when 5 variables no values2. Highlight name Yellow when 1 variable or more is present3. Highlight name Green&nbsp; when all 5 variables are present&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;cheers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

anonymous · Answer

Anonymous&nbsp;Here is my approach1. Go to edit query2. Select all five fields and click on add column tab3. Click on statistics and select count values4. Close and apply5. Right click on the name field in table visual&nbsp;6. Do the conditional formatting --&gt; format by rules and&nbsp; based on the new count column created using statistics7. create rules for green red and yellowLet me know if you have any question. If this post help mark it as solution.

Forum Discussion

Conditional formatting a field based on 5 variables

1 Reply

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting