Question

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


Badge

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

Userlevel 3
Badge +13

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.

Badge +3

Hi @gsgoraya

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

Badge +3

@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)

Reply