Forum Discussion
Solved
Conditional Formatting in Table
Hi How can I change the Background Colour to Red if the Field = "Expired" Also if the Days to Ins Expiry < 45 then i want the background to be yellow See example below:
Hi Sean-OReilly ,
Please try this:
Expired = SWITCH ( TRUE (), [Days to Ins Expiry] = "Expired", "Red", [Days to Ins Expiry] < 45, "Yellow" )
Hi Amitchandak, thanks for your reply
I see where you are coming from.
I cannot use the below formula though as the "days to ins expiry" field is a measure not a column
Can i do something similar using a measure?
Hi Sean-OReilly ,
Please try this:
Expired =
SWITCH (
TRUE (),
[Days to Ins Expiry] = "Expired", "Red",
[Days to Ins Expiry] < 45, "Yellow"
)