Look up the term "conditional format" in Excel help.
--
David Biddulph

"binar" wrote in message
...
Fellow Forum Members,
Is it possible to make EXCEL 2007 automatically color a cell as RED when I
type in the word "SHORT" into a cell in column A or color a cell as BLUE
when I type in the word "LONG" in a cell in column A? If this is
possible
can anyone give me some tips on how to accomplish such a task? Thanks in
advance.