10 Replies Latest reply on Jul 2, 2019 6:45 AM by Daryl Cox

# conditional colouring help

Morning

I am struggling to get the result i require when trying to colour the background of a column based on values within the previous column

basically the table within the packaged workboom is shown below

i am looking to colour the last column 28/01 based on the value in column 21/01

so for Aberdeen depot 21/01 = C and 28/01 = B

in this scenario a B is better than a C so would like to show this as GREEN

For Amesbury both values are a C so do not want to colour at all

For severnside the 21/-1 = 21/01 = E and 28/01 = F

F is worse than E so would like to show this as RED

Is this possible at all

thanks

Daryl

• ###### 1. Re: conditional colouring help

Hi, Daryl

Please find my solution attached.

Below is the screenshot of result for your reference.

Hope this helps

ZZ

1 of 1 people found this helpful
• ###### 2. Re: conditional colouring help

Hi,

Like this?

• ###### 3. Re: conditional colouring help

Hi

this is perfect thank you.

is there a way to colour the background rather than the text at all?

• ###### 4. Re: conditional colouring help

Hi, Daryl

You can try using Gantt chart with a size of 1 as shown below.

Also, to perfect the color, you have to create a custom color as white for the background, I just take grey to simplfy the steps.

Hope this helps, if my answer solves your question, please mark my answer as correct to close the thread. thx

ZZ

2 of 2 people found this helpful
• ###### 5. Re: conditional colouring help

Sorry to keep asking but have just been asked if its simple enough to colour the other columns too.

is it simple enough to alter the color calculated field so that it works for other column too.

i can then use this to colour the table rather than the calculation 1

thanks

Daryl

• ###### 6. Re: conditional colouring help

You can only color measures

Hämta Outlook för iOS<https://aka.ms/o0ukef>

1 of 1 people found this helpful
• ###### 7. Re: conditional colouring help

Hi, Daryl

If you always keep last 4 weeks as you did, it is doable, but a bit of complicated.

And if the number of weeks is flexible, the solution may change and use a different approach.

ZZ

• ###### 8. Re: conditional colouring help

Hi

yes the time period is fixed to 4 weeks and the user cannot change it

are you able to help me with this one please

thanks

Daryl

• ###### 9. Re: conditional colouring help

Hi, Daryl

Sorry about the delay.

Please find my solution attached. for coloring the last two columns.

Hope this helps

ZZ

2 of 2 people found this helpful
• ###### 10. Re: conditional colouring help

absolutely brilliant thanks