Skip to main content
Question

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


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.

3 replies

fmelizard
Contributor
Forum|alt.badge.img+17
  • Contributor
  • 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)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings