interior.colorindex does not work?
the cell has not conditional formating
bst wrote in
:
ok, i have learned about conditional formating. maybe for what i want
to do i should try using it instead. i am pretty sure however that
there is no conditional formating on the cell already. this actually
looks like a pretty neat method. is it any better or quicker than?: if
conditon
set cell color
end if
still, i don't think that is why my original code will not work. any
other ideas. i'm working with excel 2000 if that matters. um also
screen update is turned off, but then turned back on at the end of the
sheet. i dont think this matters because i do the same in other macros
as well with desired results.
thanks
bst
bst wrote in
:
point me in the direction to learn more about conditional formatting
please. probably since i don't know anything about it, its not
there, but i don't build the raw report so maybe it is there.
thanks for the quick reply
bst
Susan wrote in
news:0ebf7d9c-a77f-4f13-aa79-0b8a1ebf8a50@
34g2000hsh.googlegroups.com:
if you already have conditional formatting applied to that cell,
then it will take precedence over the colorindex command......
try clearing any conditional formatting & running it again.
hth
:)
susan
On Jun 27, 3:53*pm, bst wrote:
is there something wrong with the following line(assuming with
Sheets ("Sheet1") and that i want the cell to be red?:
.Cells(rowCtr, colSig).Interior.ColorIndex = 3
i have used this method quite a bit and it works in other scripts
that i use on different reports.
at the end of execution the cells are not colored, however using
msgbox(.cells(y, x).interior.colorindex) gives me 3, so i know it
is executing.
is there some setting in the sheet itself that would keep this from
executing with the desired results(i want the cell to be filled
red).
the only think i could think of to check is the pattern property of
interior and it is 1 (solid) so that seems correct to me.
anyone have any ideas?
TIA
bst
|