Forum Discussion
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...
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
Hi Anonymous ,
Pls refer the below:
Rule = SWITCH(MAX('Table'[type]),"A","Green","B","Red","C","Yellow")
Then
Final output:(color according measure rule)
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
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