Hi, John. You need to use the three conditions of CF.

Set your first condition to Formula Is: =$B$1-$A$1<=7 and set the
Pattern fill color to Green

Set your Second condition to Formula Is: =AND((B1-A1)7,(B1-A1)<15)
set the fill to Yellow

Third condition to Formula Is: =$B$1-$A$114 with fill to Red. Be
mindful of the text color that is used with the fill colors, as some
work better than others with each color.

Does this work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=375215