You're on the right track.

Use Data - Validation
On the Settings tab under "Allow" choose Custom
In the "Formula" area type: =A1<=2500
(Change the A1 to whatever cell you're working with)

Now on the Error Alert tab in the "Style" area choose Warning
Then type in a title and text for your warning
Click OK


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=489619