You can't do it with a formula in the cell.
But you may be able to do what you want based on conditional formatting.
Format|Conditional formatting
is where I'd start (xl2003 menus)
That, and Debra Dalgleish's site:
http://contextures.com/xlCondFormat01.html
DLHedges wrote:
I would like to have the cell turn a certain color with an "If", "Then"
formula. Is that possible?
--
Dave Peterson