Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 4th 06, 05:16 PM posted to microsoft.public.excel.worksheet.functions
Financial Admin
 
Posts: n/a
Default A function to make date red if it is over 30 days old

Im so confused and just just got a new position where I will need to track
how long we have been working on certain cases...

Please explain step by step.

Thank you so much!!!!!

  #2   Report Post  
Old January 4th 06, 06:07 PM posted to microsoft.public.excel.worksheet.functions
intruder9
 
Posts: n/a
Default A function to make date red if it is over 30 days old


You could use conditional formating. Say you chose a cell A1, in this
cell you enter the date you are looking to compare to the date in
question. Select the date you want to turn red, for this example we
will use F3 and click FORMAT CONDITIONAL FORMAT chose "Formula is"
in the drop down box and for the formula put =(F3-A1)30, now press on
the format box and choose red for the font color. Whenever this is
above 30 days apart the date will turn red.


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=497972

  #3   Report Post  
Old January 4th 06, 08:52 PM posted to microsoft.public.excel.worksheet.functions
Financial Admin
 
Posts: n/a
Default A function to make date red if it is over 30 days old

Hi!
This worked for me only when I delete the date (NOW) after I complete the
conditional formatting. I found this out by accident... When I left the
conditional formatting box and got fustrated and deleted the cell that I have
"NOW" formula for today's date, the formatting was applied and I got the
result.. Is it supposed to do that?

"intruder9" wrote:


You could use conditional formating. Say you chose a cell A1, in this
cell you enter the date you are looking to compare to the date in
question. Select the date you want to turn red, for this example we
will use F3 and click FORMAT CONDITIONAL FORMAT chose "Formula is"
in the drop down box and for the formula put =(F3-A1)30, now press on
the format box and choose red for the font color. Whenever this is
above 30 days apart the date will turn red.


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=497972




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert date of birth to mos. old now, 30 and 60 days Samantha Excel Worksheet Functions 1 August 29th 05 11:29 PM
Date Function Dee Excel Worksheet Functions 8 August 12th 05 08:04 PM
Calculating days between current date and a date in future NETWORKDAYS() function Faheem Khan Excel Worksheet Functions 2 February 10th 05 07:18 PM
Include Saturday in the WORKDAY function kippi3000 Excel Worksheet Functions 9 December 31st 04 08:21 AM
Formula for date function Markitos Excel Worksheet Functions 15 November 10th 04 02:05 AM


All times are GMT +1. The time now is 12:40 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017