for each row(
Hi folks,
I want to colour my cells by value,
so if the row is <= 25 red, if > 25 and < 50 orange , if> 50 < 70 yellow.
and >75 green.
i am breaking it down to test first and when i run the first 2 arguments, the second condition changes all the rows to orange
for each row(
if(:CDO 4 week Avg <= 25,
dt:CDO 4 week Avg << color cells("Red", Row()),
:CDO 4 week Avg > 25 <=50,
dt:CDO 4 week Avg << color cells("orange", Row())
)
);
I cant understand why I am overwriting the condition and changing all cells colors to orange
Second comparison seems wrong.
Try changing:
:CDO 4 week Avg > 25 <=50,
to
25 < :CDO 4 week Avg <=50,
And is it possible to loop this for each column or do i have to make a for loop for each of the columns?
