Look at formats _ conditional formating

If the percentage is in a cell

condition 1 cell value is greater than or equal to 0.5 format cell as
red

add

condition 2 cell value is greater than or equal to 0.25 format cell as
orange

add

condition 3 cell value is greater than or equal to 0.1 format cell as
yellow

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=562343