I am new to Office 2007, and am using the updated Conditional Formatting for
the first time. I like what I'm seeing, but I don't see the default
functionality I seek.

I'm looking for:
Format Style: Icon Sets
Icon Stule: 3 Traffic Lights (Unrimmed)
Cell value "Red", "Yellow", or "Green".
Default is cell is a percentage, and I can't determine how to get a
word/text value.

Goal: conditionally format as mentioned, then, on a daily basis, go to the
cells, and enter "Red," "Yellow," or "Green" for each cell and have the
Traffic lights display with the words "Red," "Yellow," or "Green".

Can this be done?

If not, I'll stick with my manually-created rule that shades the cell
red/yellow/green based on me typing one of those three words.

Thanks,
Mike