Forum Discussion
Can we implement multiple colors into one cell using Conditional formatting or suggest any method
Hi All,
Here it's my scenario, There would be an absence reason with a list of codes by each employee.
Example :
EmpID - 24563
Absence Reason - Unscheduled
List of codes - 170,195,150
Each of the codes occupied time hours - 170(2.7),195(0.3) and 150(6),
Date - 05/23/2022
In the above scenario, one cell occupied the list of codes for the same date. For Each code, we can differentiate the status by colors in one cell.
Looking forward your support and help !
Hi FJ83
You can try conditional formatting.
Just enter the build visualization option and pick the colum you want to change.Next you go to rules option and the format style
After that you pick the meaure you want to base the colors on. In your case it seems to be a status and you pick the color for each of the given statuses.
If only works with numbers so you might need another measure that goes something like
Measure = if(Absence Reason = Unscheduled, 1,
if(Absence Reason = Scheduled, 2,
if(Absence Reason = Done, 3, 4)))
I hope this help you.
4 Replies
Hi Anonymous
You can only have 1 color in a cell (table, matrix?). But if you had the codes in separate celsl then you can color each one differently.
Regards
Phil
Hi FJ83
You can try conditional formatting.
Just enter the build visualization option and pick the colum you want to change.Next you go to rules option and the format style
After that you pick the meaure you want to base the colors on. In your case it seems to be a status and you pick the color for each of the given statuses.
If only works with numbers so you might need another measure that goes something like
Measure = if(Absence Reason = Unscheduled, 1,
if(Absence Reason = Scheduled, 2,
if(Absence Reason = Done, 3, 4)))
I hope this help you.
