For this example, the input cell is A1 and the compare cell is B1

A1: 06/22/2005
B1: 06/10/2005

Select A1
FormatConditional Format
-Condition 1
---Cell value is greater than =$B$1
---Format: Pattern:RED, Font Color:White
-Condition 2
---Cell value is between =$B$1-30 and =$B$1
---Format: Pattern:YELLOW, Font Color:Black
Click [OK]

That should do it....
Does it?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=381433