Skip to main content
Solved

HOW to assign RED Colour to CELL in Excel File ?

  • May 31, 2024
  • 2 replies
  • 137 views

vimva679
Supporter
Forum|alt.badge.img+9

How to assign RED colour to this cell in final output of EXCEL file.

 

Because TESTFILTER have filtered this Column, whatever Rows are there, irrespective value inside the cell i would like to assign RED colour to the CELL marked with a Blue circle inside final excel file, 

 

 

 

 

this is default OUTPUT 

 

This is how I WANT

 

Best answer by jkr_wrk

I think your answer is here:

The same way you test on the color, when reading, you use that attribute to write the color when writing.

On this page there is a paragraph formatting:

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/xlsx/XLSX_writer.htm

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

jkr_wrk
Influencer
Forum|alt.badge.img+35
  • Best Answer
  • June 2, 2024

I think your answer is here:

The same way you test on the color, when reading, you use that attribute to write the color when writing.

On this page there is a paragraph formatting:

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/xlsx/XLSX_writer.htm


vimva679
Supporter
Forum|alt.badge.img+9
  • Author
  • Supporter
  • June 7, 2024

It works perfectly now please find the solution to write the colour in cell of excel file