Highlight a cell through macro

[macro_user]

hi...
i have a loop which runs through column A and column B and if the value of column A is less than the corresponding value(same row index) of column B, then i need to highlight both the cells...
Appreciate the help...

 

[macro_user]

i just did trial and error with wat was here and i figured it out

Cells(11, "I").Interior.ColorIndex = 3        'red
Cells(11, "G").Interior.ColorIndex = 6        'yellow

Thanks guys...

 

[schielrn]

Here is a link with the colorindex values for the 56 colors in pre-excel 2007 color pallette:

http://www.mvps.org/dmcritchie/excel/colors.htm

Hope that helps.

 

[macro_user]

Thanks Schielrn but my requirement was just to highlight it in red... but anyway, would have a look at it after i complete my project

Thanks anyways

 

[macro_user]

hi... how would i revert all the interior colors to the default one? is the default one is white, how do i do tat? this is because, i highlight few cells in a report... when i re-generate the report, i clear all the cells in the report and then beginning processing...
so when i clear the cells, only the cell contents would be cleared right? i need to revert all the previous highlighted cells to the default color when im trying to regenerate the new report in the same worksheet...
Thanks for ur help...

 

[schielrn]

You could use the clearformatting method.

Rnage("XYZ").clearformats

or set the colorindex to -4142 or I believe you can also use xlcolorindexnone.

Hope that helps.

 

[macro_user]

Thanx for tat...