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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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!