Conditional Colors in a CELL
 

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.

Conditional Colors in a CELL
 

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.

Conditional Colors in a CELL
 

Hi,

Use conditional formatting for this.

http://www.contextures.com/xlcondformat03.html
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"binar" wrote:

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.