Hello WF Community, I would like to see if anyone knows how to build a conditional format under multiple conditions/column on a report. The conditional format I am trying to set up is:
If the Business Rank is null and the project status is In Progress or Planning, the Business Rank cell should highlight in red (to tell us a rank is missing)
If the Business Rank is null and the project is in Idea status, the Business Rank cell should not highlight in red
Right now I've managed for both rules to work, however, it is also now highlighting when the Business Rank is not null for projects In Progress or Planning. Attached are screenshots of the columns + the rule I set up. Does anyone have a solution they could share? Thanks! Nick Vivanco