Forum Discussion
Conditionally format cells in column based on text value of another column
Hello, I have the following table and i want to conditionally format the "Action date" column cells based on the text in "Category" column. 1. If text "Late", then add red circle icon next to value...
I would create a conditional column in Power Query to assign a number to each "status" (conditional formatting likes numbers).
Then you can apply conditional formatting based on the number value
Giving this result.
I would create a conditional column in Power Query to assign a number to each "status" (conditional formatting likes numbers).
Then you can apply conditional formatting based on the number value
Giving this result.