Conditional Formatting - Looking for Red/Yellow/Green Icons, w/ wo

M

mikevanv

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting to Another Cell 0
Conditional formatting dates 3
Excel 2010 Conditional Formatting 2
Date Conditional Formatting 4
Look up by the Icon Set Color 0
Conditional format - 3 traffic lights 2
Conditional Formatting for 4 conditions 2
Using the Icon Set for Conditional Formatting 1

Top