Hi Miki, check out:-

http://www.pierrefondes.com/

Items 32 and 31.

This is something similar to what you want. All you need to do is to
customize it.

In the EXCEL 2007 Workbook the range L 1 to L 100 has been Conditionally
Formatted as per the rules in the WORD doc.

You can check it by entering values in the L 1 to L 100 range.

Entering numbers 1 to 30 in the said range return red.

Entering numbers 31 to 69 in the said range return orange.

Entering numbers 31 to 69 in the said range return orange.

Entering numbers 70 to 100in the said range return red.

Just amend the settings in the WORD doc to suit your requirements.

If my comments have helped please hit Yes.

Thanks.


"Miki" wrote:

I'm trying to conditionally format a row of calculated values displayed at
percents with icons such that 0% - green light, < 0% - red light.

Any insight would be appreciated.

Miki