Forum Discussion
Help creating an IF statement with MULTIPLE CONDITIONS and CONDITIONAL FORMATTING
I have a Power BI dashbaord report that I use to do auditing. I would like specific columns inside the table to automatically highlight in yellow if certain conditions are met. My tables column A has 4 different selections. Therefore, if Column A meets condition A, OR condition B OR condition C OR condition D, then columns B, C, D, E and F CANNOT be blank and if they ARE blank, I want these columns to be highlighted in yellow.
TABLE NAME = Investigations
Column A Name = Role In Incident
Column A conditions/options are:
- Root Cause Associate
- Root Cause Vendor
- Root Cause Business
- Root Cause Employer
Column B = First Name
Column C = Last Name
Column D = Department Name
Column E = Supervisor First Name
Column F = Supervisor Last Name
Therefore if Column A meets any of the above 4 conditions then columns B, C, D, E and F CANNOT be blank. If they are blank then I want it to highlight the column in yellow that is blank.