Forum Discussion
Solved
Conditional Formatting Logic Puzzle
Hey all, This feels like a big logic puzzle to me but I don't have enough tools in my toolbox to solve it. I need to be able to set up some type of conditional formatting rule or an if/then logi...
Shawna760 I have included 2 options for the text but for the color (conditional formatting) you will need 5 rules.
For the value in the cell you could use INDEX() as a lookup or 'build' it based on the probability converting to a letter and then appending the severity.
For the color (conditional formatting) I show how by multiplying the 2 values you can create distinct ranges for each zone.
hope this helps and btw I am in quality and regulatory so very familiar with your risk assessment chart 🙂
Thank you very much OliverScheurich and mtarler! I took a look at both of your solutions and understand the conditional formatting. I will spend some time looking into the index, indirect and char formulas to understand them better but I can see that all of them accomplish the goal. mtarler fun connection, you got it, definitely risk assessment.
All the best,
Shawna
All the best,
Shawna