LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: cristi.boizas

Hi,

Is there any way to format the cells on a column output in excel ?
I have a percentage like this:
Percentage
13.00
50.00
100.00

and I want the output to color the cells like: Red < 50.00, Yellow - [ 50, 100) , Green - 100
So basically:
Percentage
13.00 - Red
50.00 - Yellow
100.00 - Green
Hope you have any answer.

I currently researching to write in a formula embedded in the data which Excel would automatically recognize and apply in the cells where it is written, but I don't know if it possible at this time.

Thanks a lot!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

Sure, you can set up an Excel template with conditional formatting, then use that template in an Output Excel node. See attached. You'll need to change the location of the template and also the output file.
Attachments:
CondFormatting.zip

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: cristi.boizas

Ok, thanks