Conditional FormattingCell Value is: "Turned Down" would be the easiest
without any VBA.

In 2003 you only get 3 conditions per cell.......4 if you count default.

2007 has increased that limit to 64......I think<g


Gord Dibben MS Excel MVP

On Tue, 6 Apr 2010 16:55:01 -0700, Napoleon Vang
wrote:

How can I make it so that everytime I type say the phrase "Turned Down" it
appears in red throughout a specific column? And "Booked" would appear in
green, etc. other phrase/color combos also?