How do I change the color of a cell in Excel based on a Condition?

Question

I want to change the color of a cell in Excel bases upon the text in the cell being the value "TRUE"

I tried this statement, but I get an error...can someone help me?

I am using Microsoft.Office.Interop.Excel

if (excelApp.Range[rowIndex, colIndex].Value = "TRUE")
            {
                excelApp.Range[rowIndex, colIndex].Interior.ColorIndex = 4;
            }
            else
            {
                excelApp.Range[rowIndex, colIndex].Interior.ColorIndex = 3;
            }

thanks

J

Amit Choudhary · Answer

i got one more solution: try this: oSheet.Cells[1 1] = First Name; if(oSheet.Cells[1 1]==First Name); oSheet.Cells[1 1].Interior.Color=4;

Amit Choudhary · Answer

hi friend you have to change the indexing scheme as follows: excelApp.Workbooks.Open(myPath); int rowIndex = 1; char colIndex = 'A'; excelApp.Cells[colIndex+rowIndexcolIndex+rowIndex] = True; if (excelApp.Range[colIndex + rowIndex colIndex + rowIndex].Value = True) excelApp.Range[colIndex + rowIndex colIndex + rowIndex].Interior.ColorIndex = 4; else excelApp.Range[colIndex + rowIndex colIndex + rowIndex].Interior.ColorIndex = 3; now you can have increment in the colindex in a special manner. Increment colIndex value with 1 so that it goes like ABC... when it comes to last Z then you have to start like AAABACAD...... etc. Hope it helps you.

j l · Answer

Here are my Visual Studio solution files.. I get an exception error at the IF statement line.....if (excelApp.Range[rowIndex colIndex].Value = TRUE) What I want 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 thanks J

Amit Choudhary · Answer

hi dear Can you please post your complete code here i don't how you accessing the file?? And also what error you are getting???

j l · Answer

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

Amit Choudhary · Answer

hi friend below code will solve your problem... i have tested it. oSheet.get_Range(A1 AV1).Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Green); Don't forget to mark as answer if it helps you.