Hi everyone, I'm trying to make one of the variables (Currency) highlighted to the colour yellow on the Excel output if it doesn't equal to USD but it comes up as "Parse Error", please could I get some help?
If the variable Currency, does not equal to USD, EUR, GBP,...., & AUD, then highlight the Excel output cells the colour yellow. Any screenshots or data would be appreciated. Also, I need this to be a column rule.
There are roughly 200 currencies I need to do this for.
I agree with @Pingu. If you need to include 200 currencies though there may be a better way so you don't have to worry about maintaining a giant in clause. Some ideas that come to mind are joining a list of currencies to your data, flagging the fallouts, unioning them back, and using the flag field to drive the highlight. That way you can simply update the list if you have changes in the future.
If you want to go with the NOT IN clause, you can pass your list through a summarize tool to concatenate it for you to put into the formula