CELL FORMULAS
 

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)

CELL FORMULAS
 

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)

CELL FORMULAS
 

Hi Alexandra

Use Conditional Formatting..

1. In cell A1 enter todays date (Ctrl+Shift)
2. From menu FormatConditional FormattingCondition1Select 'Formula Is'
and enter the below formula
=$A$1-TODAY()<5
3. Click Format ButtonPattern and select your color (red)
4. Hit OK

If cell A1 will be in red color if the date entered is 5 days prior to
current date. Check and feedback

If this post helps click Yes
---------------
Jacob Skaria


"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)

CELL FORMULAS
 

A small correction.

To enter todays date (Ctrl+;)

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Hi Alexandra

Use Conditional Formatting..

1. In cell A1 enter todays date (Ctrl+Shift)
2. From menu FormatConditional FormattingCondition1Select 'Formula Is'
and enter the below formula
=$A$1-TODAY()<5
3. Click Format ButtonPattern and select your color (red)
4. Hit OK

If cell A1 will be in red color if the date entered is 5 days prior to
current date. Check and feedback

If this post helps click Yes
---------------
Jacob Skaria


"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)