Forum Discussion
Solved
Help with multiple conditional formatting please
Hello everyone. I was hoping someone could help please. I have 4 columns in a table, each column is a separate field from the same query. The columns as per the picture below, are QC Planned Sta...
Hi !
You can create a column using following DAX to calculate if Planned End Date >= Actual End Date, you can do similar for Start date as well.Planned End Date High = IF(Table[QC Planned End Date] >= Table[QC Actual End Date], 1, 0)Now you can use this field in conditional formating, go to Format -> Conditional Formatting -> Background color -> On;
Colors4
You can adjust the Red & Green color based on your requirement.
Regards,
Hasham
Hi !
You can create a column using following DAX to calculate if Planned End Date >= Actual End Date, you can do similar for Start date as well.
Planned End Date High = IF(Table[QC Planned End Date] >= Table[QC Actual End Date], 1, 0)
Now you can use this field in conditional formating, go to Format -> Conditional Formatting -> Background color -> On;
Colors4
You can adjust the Red & Green color based on your requirement.
Regards,
Hasham