Flag a date in Excel

  • Thread starter Thread starter Soolin
  • Start date Start date
S

Soolin

I wish to flag a date so that 10 days later, the input date will tur
red so that I can follow it up. I have seen it done but don't know ho
to do it. Please hel
 
Try using conditional formatting:

Select the cell(s)

Click Format > conditional formatting

Put the settings "Under Condition 1" as :

Formula Is | =TODAY()-A5>=10

Click Format button > Font tab > Color > Red > OK

Click OK

--
hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com
for email
 
Maybe Format|conditional formatting
then use a "formula is" like:
=A1<TODAY()-10
and give it a nice bold red format.
 
You can use conditional formatting to flag the date:

Select the cell (e.g. cell A2)
Choose Format>Conditional Formatting
From the first dropdown, chose Formula Is
In the formula box, type: =A2+10<=TODAY()
Click the Format button
On the Patterns tab, select the Red colour
Click OK, click OK

If the date is ten days ago, or earlier, the cell will turn red.
To flag a date that was exactly ten days ago, change the formula to:
=A2+10=TODAY()
 
Formula Is | =TODAY()-A5>=10

sorry, just to clarify:
the formula given above presumes cell A5 is selected
--
hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com
for email
-------------------------------------------
 
Thanks all for the response! Haven't had time to try it yet, but loo
forward to the testrun!
I appreciate all the input, thank you
 
Back
Top