Hello there, sorry for asking topics not relevant to Power BI. The question is for Microsoft Excel. Hope you guys can help me!
I want to make Conditional Formatting based on colour in columns R, Y and B. I will make new column next to the column B. The new will use to show the result based on the colour in columns R, Y and B. So the new excel should be like this:
So meaning that:
- 2 Yellow = Priority 1
- 1 Red = Priority 1
- 1 Orange = Priority 1
- 1 Yellow, 2 Green = Priority 2
- All Green = No Action
Hope you guys can guide me. Thank you.
