Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

CONDITIONAL FORMATTING BASED ON RAG

HI I have a table status value R 1 A 2 G 3 I need an output like Whenever the table is having a value R, the output should come as red icon, if A then output should come as Amber icon. TIA
  • Unfortunately, you cannot set icons for text values in Conditional formatting.

    In this case, you need to create an additional StatusID column (number type), e.g. R-1, A-2, G-3 and set icons for the given status based on this column. Below screen:

    _______

    If I helped, please accept the solution and give kudos! 😀

2 Replies