Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
veryimportantdude
Contributor III
Contributor III

Excel set cell colour

Hello
Is it possible to set field colour in an excel Output file based on condition?
For example:
if value <0:
colour = red
else:
colour = green

thank you
Labels (2)
2 Replies
Anonymous
Not applicable

Hi
You mean you want to set background color of cell by TOS directly?
I think it is impossible to do this. Because TOS doesn't import thirdparty library for this demand.
Best regards!
Pedro
juliusmark
Contributor
Contributor

Hi Guys,

I also have the same requirement. Has anyone did it already?

Can this be achieved using the tFileExcel-Components found at:
https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

 

Cheers!