Sometimes we get requirements to highlight a specific cell
of a table depend on the final value. In my example below, I calculate the
value falls under “Weeks” column and need to make the cell Bodycolour to Red if
the value is greater than 10. Here are the steps.
Go to Text Box properties and use the IIF condition.
Ex:
=IIF((<<Expr>>) >=10 ,”Name(code) of the colour if the condition is TRUE”, “Name(code) of the
colour if the condition is FALSE”)
No comments:
Post a Comment