Can we implement multiple colors into one cell using Conditional formatting or suggest any method

[Anonymous]

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 !

[ThomasWeppler · Accepted solution]

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.

[Anonymous · Accepted solution]

Thanks 

[ThomasWeppler · Accepted solution]

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.

[PhilipTreacy]

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

[Anonymous]

Thanks Phil