microsoft.office.interop.excel

Hello. How can I use Interop Excel to perform conditional formatting on excel cells? In the cells from A1 to A100, I have a drop-down list where the user can choose one of the currencies "USD, EUR, CNY". Initially, the cells are empty—the user selects the currency only after opening the file...