I have created a excel template with Visual Studio (c#) to fill the worksheet with some data.
On this worksheet I want to add some conditional formatting of the cells. I want the user of the template to fill in a "Yes" or a "No" and make the cell green / red depending on the value of the cell. Any idea how to do this?
I found a lot on the net about conditional formatting, but I can't figure out how to do this. :confused: