Color cells based on multiple conditions
I have written the following code to color the cells based on condition.I need to add one more condition -
if weight is within -2% of Target then need to color cells yellow.How do I do this?
dt << New Column("color cells",
Formula(If(:Target> :weight, :weight << color cells("Red", Row()); .,
:weight << color cells("Green", Row()); .)),
Hide(1)
);
Thanks