Loading

Change the color of a cell based upon a Condition statement?

j l

Hello Im using Visual Studio 2010 beta release.. and Excel Interop library
Let me explain better what I'm trying to do:

If the cell value of A1 is the text "TRUE", then I want to change the cell background of A2 to color GREEN
How do I do this?
J

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

j l16y ago
Hello
Here is the code that I've tried. I get an exception error at the "IF" statement

int rowIndex = 1; int colIndex = 1;
excelApp.Cells[rowIndex, colIndex] = "True";
if (excelApp.Range[rowIndex, colIndex].Value = "True")
excelApp.Range[rowIndex, colIndex].Interior.ColorIndex = 4;
else
excelApp.Range[rowIndex, colIndex].Interior.ColorIndex = 3;

Can anyone tell me whats wrong with my code?

J
Sam Hobbs16y ago
Use Range.Interior.Color. Do you know how to use ranges?