CELL FORMULAS

  • Thread starter Thread starter ALEXANDRA
  • Start date Start date
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)
 
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.
 
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
 
Back
Top