Format Output Excel using Table Tool

[KrishnaChithrathil]

Can we perform this?

Fill the entire Variance and Unit row & if Variance != 0, change the unit value color to Red.

Thanks,

Krishna

[KrishnaChithrathil]

@oliverd 

The sheet i'm using is not the existing one. It's being created dynamically.

[oliverd]

It's only if there is an existing formatting.

[DataNath]

@KrishnaChithrathil are you able to share your workflow at all or show a wider picture? Struggling to recreate the issue myself -

String:

Numeric:

[KrishnaChithrathil]

@DataNath 

I can understand. but since it contains client information, I'm not supposed to share that.

But to be said, whatever you've provided seems to work in every possible scenarios.  That look perfect though. But somewhere something I'm missing out. 

[DataNath]

No problem @KrishnaChithrathil - my only other suggestion would be to try deleting the Table tool and re-adding it and then trying both ways i.e. with quotes and string data type and without quotes with a numeric data type. That error you're getting definitely occurs when there is a difference i.e. trying to apply a string expression to a number or vice versa. If those don't work then I'm not too sure what else to check without seeing the workflow as I can't replicate it myself.

[KrishnaChithrathil]

@DataNath 

Sure. I'll check.

Thanks,

Krishna