I searched in googles groups search I could not get satisfactory answer.

in the inermediate window if I type

activecell.inteiro.colorindex=3 the cell turns red (i.e filled with red
color)

in the same window if I type

?activecell.interior.colorindex
it gives result as
46

In a sub If I use a statement
if activecell.interior.colorindex=3 then -------------
it does not receognise that the cell color is red

But if I type
if activecell.interior.colorindex=46 then -------
it works.

clarifications sought. thanks