Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditionnal formatting cells from table

Hi,   I am thinking on how to get my cells formatted based on calculations but can't find a solution currently. Don't know whether to use the IF or SWITCH function for it as SWITCH only seem to app...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi v-luwang-msft ,

     

    Solved it by creating a column like below and doing conditionnal formatting based on numbers 1 till 5.

     

    _Colour =
    IF(AND(G002_KDE_BI_Report[_IODDate] <= G002_KDE_BI_Report[_ArrivalDate], G002_KDE_BI_Report[_Bin] = "IOD received"), 1 ,
    IF(AND(G002_KDE_BI_Report[_ArrivalDate] = TODAY(), G002_KDE_BI_Report[_IODDate] = BLANK()), 2,
    IF(AND(G002_KDE_BI_Report[_ArrivalDate] < TODAY(), G002_KDE_BI_Report[_Bin] = "Shipped"), 3 ,
    IF(AND(G002_KDE_BI_Report[_IODDate] > G002_KDE_BI_Report[_ArrivalDate], G002_KDE_BI_Report[_Bin] = "IOD received"), 4 , 5)
    )))
     
    Kind Regards,
     
    Sofiën
AnamPatel's avatar
AnamPatel
Resolver II
4 years ago

There is an easier way to do Conditional Formatting. You can achieve this without a measure as well. Below are the steps –

Click on the Down Arrow in front of the Column Name under Values Tab and Select Conditional Formatting > Background Color

 

 

A new Background Color window will pop up – fill all the details, select the colors you want and click on OK.

 

 

 

 

That’s it, the colors will show up on your chart –

 

 

Let me know this works for you.

 

If I answered your question, mark my response as a Solution. Appreciate your KUDOS! (To Like, or Kudo a post, click the yellow thumbs up box in the bottom right corner.)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi AnamPatel 

     

    I know you can do it like this as well, but this won't work for me as my colours are based on calculations which I mentioned above. In the screen you shared you need to select Field Value after selected Conditionnal Formatting and then within Field Value enter the measure with SWITCH function probably.

     

    Kind Regards,