Conditional formatting should do the trick (Format?Conditional Formatting)

Not sure of the actual syntax of the formula you would need to use but I'm
sure someone else could help you there.

"ALEXANDRA" wrote:

HOW DO I CREATE A FORMULA IN CELL(S) WHICH WILL ALERT ME? FOR EXAMPLE, I
WOULD LIKE THE A DATE (SEPT. 1) TO TURN RED 3, 5 OR EVEN 30 DAYS PRIOR TO
(SEPT. 1)