if <your condition then
range().Interior.ColorIndex = ' enter a # 1 thru 56
end if

susan

On Jan 31, 9:59 am, dbizek wrote:
Is there a way to program cell fill colors on and off.
Either using the "IF" statement or some other way?