if range("a1").interior.ColorIndex=3 then msgbox "hi"

--
Don Guillett
SalesAid Software

"Susan" wrote in message
...
Hi, I'd like to write a formula with IF function, using a cell color as a
criteria. Is this possible?

Like,
=IF([cell.fill.color]=red,[dothis],[dothat])

Thanks.