Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Carrying formulas over to new cell when old cell is deleted: possi | Excel Worksheet Functions | |||
CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS. | Excel Discussion (Misc queries) | |||
How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
change cell value greater than another cell value using formulas | Excel Worksheet Functions |