CELL FORMULAS

A

ALEXANDRA

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

Ivor Davies

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.
 
J

Jacob Skaria

Hi Alexandra

Use Conditional Formatting..

1. In cell A1 enter todays date (Ctrl+Shift)
2. From menu Format>Conditional Formatting>Condition1>Select 'Formula Is'
and enter the below formula
=$A$1-TODAY()<5
3. Click Format Button>Pattern 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
 
J

Jacob Skaria

A small correction.

To enter todays date (Ctrl+;)

If this post helps click Yes
 
Top