Forum Discussion
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! 😀
lkalawski
Resident Rockstar
Resident RockstarUnfortunately, 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! 😀