Is there a way to set the colour (background or text) of a row in excel based on an attribute value?
I would like to be able to highlight certains rows in the file based on whether they passed or failed validation.
Question
setting excel row colour
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.
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.
+21- Safer
Hi,
I dont think there is a way to it via an attribute value. You could alternatively use different writer feature types that will result in different tabs.
Hi,
I can't think of a way to do this in FME but in Excel you can colour cells or entire rows based on a condition. Navigate in Excel to the Home tab, Styles group, and choose Conditional Formatting > New Rule....
+40- Contributor
Unfortunately I'm already using different tabs for other reasons. I was hoping to avoid having to make any changes in the excel file post process.
+15- Contributor
...you can try using python to do that.
from win32com.client import Dispatch
import os
etc.
There are sample codes out on the net.