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

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;

hi friend,

you have to change the indexing scheme as follows:


 excelApp.Workbooks.Open(myPath);
            int rowIndex = 1;
            char colIndex = 'A';

            excelApp.Cells[colIndex+rowIndex,colIndex+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 A,B,C... when it comes to last Z then you have to start like AA,AB,AC,AD,...... etc.

Hope it helps you.

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

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???

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

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.