In the worksheet, you can't

in a vba routine (not used as a function in a worksheet)

if condition then
activeCell.Interior.ColorIndex = 5
End if
--
regards,
Tom Ogilvy

"Shaul" wrote in message
...
Hi,
Can someone help me how can I change a cell color using the"IF"
command???
Thank you,
Shaul