Skip to main content
Question

Highlight a row if one cell has a specific value in Excel

  • July 27, 2017
  • 3 replies
  • 112 views

Forum|alt.badge.img

Hello All,

I want to use FME to highlight a row if column "E " containing value higher than 700. Wondering if it is possible in FME. I have attached Excel sheet for your kind consideration.

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.

3 replies

fmelizard
Safer
Forum|alt.badge.img+22
  • Safer
  • July 27, 2017

Hi @gsgoraya, although I have never highlighted a cell based on a condition such as yours. I know you can change the colour of the text if the value meets a condition. We have an article about the Excel Writer parameters that may help you out with this.


lars_de_vries
Forum|alt.badge.img+10

Hi @gsgoraya

I think you should be doing this in Excel using conditional formatting.


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • July 31, 2017

@gsgoraya

call a vb script trough a bat file wich you call using a system caller.

vb script like:

(this will color the empty cells also..need to fix that)