Search : in
By :

Excel: If date >= 30 days, cell change color

Last answer on Sep 25, 2009 11:55:44 am BST purplePashun, on Apr 21, 2009 2:21:37 am BST 
 Report this message to moderators

Hello,

I have a date, say 3/1/09 in cell A1. I want cell B1 to change color if A1 is over 30 days. How can I do this?

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Excel: If date >= 30 days, cell change color » in :
How to make a cell change colour Show
Excel IF Then Statements Show
[Excel] Adding a fixed date in a cell Show [Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Mktime() - Timestamp yesterday, last month, etc.). ShowMktime() - Timestamp yesterday, last month, etc.) Intro Last 24 hours Yesterday This week Last week This Month Last 30 days (last 30 days) Last month Current year(this year) Last year (last year) Intro The mktime()function...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

vangogh34, on Apr 21, 2009 9:37:58 am BST
  • +24

Hi,
this is called Conditional Formatting.
click on "Conditional Formatting" icon and then "Highlight Cells Rules" and enter the data.

   
Reply to vangogh34

2

purplePashun, on Apr 22, 2009 1:36:19 am BST

Vangogh34,

Thanks, that was very helpful. This works when you input a value into cell B1 with a set criteria linking cell A1. However, what happens if the date in A1 is...say, 03/01/09, and this date is over 30 days from the system date...so cell B1 is triggered (changing color) as a reminder to the user to follow-up. Is a code required for this?

purplePashun

   
Reply to purplePashun

3

mubashir aziz, on Apr 22, 2009 7:14:20 am BST
  • +8

Put this formula on A1 cell so if it will be delay more than 30 days from today's data. A1 cell will be highlighted and no need to create an extra cell ...

Put below formula in conditional formatting when you are in Cell A1.

=(A1+30)<TODAY()

   
Reply to mubashir aziz

4

purplePashun, on Apr 24, 2009 3:03:02 am BST
  • +1

Mubashir aziz,

Thank you...thank you! This works!!! Apreciate all your help. : )

purplePashun

   
Reply to purplePashun

5

mubashir aziz, on Apr 24, 2009 4:35:41 am BST

U r always welcome

   
Reply to mubashir aziz

6

sami, on May 18, 2009 6:59:00 am BST

Hello mubashar bhai H r u > i hop u will fine. my dear brother i m in a problem befor 5 days. main dubai mein 1 compnay mein kaam karta hoon. masala yeh hai k kiya koi aes formula ya koi aesa option hai excel mein agr aaj ki date computer mein hai 18-05-2009 to excel ki sheet no 01 mein ya kisi b sheet mein kisi cell per aaj ki date 18-05-2009 likh dain jesay hi computer ki date change ho to cell ki date khud ba khud change ho gaye. please aap yeh masal hall kar dain main aap ka bohat mashkoor hoon ga.


My name is muhammand iftikahr sami form
Dubai

   
Reply to sami

9

 Smokeysan, on Sep 25, 2009 11:55:44 am BST

Thank you for this!!! It works exactly the way I want it to.

   
Reply to Smokeysan

7

mubashir aziz, on May 19, 2009 7:34:31 am BST

Hello mubashar bhai H r u > i hop u will fine. my dear brother i m in a problem befor 5 days. main dubai mein 1 compnay mein kaam karta hoon. masala yeh hai k kiya koi aes formula ya koi aesa option hai excel mein agr aaj ki date computer mein hai 18-05-2009 to excel ki sheet no 01 mein ya kisi b sheet mein kisi cell per aaj ki date 18-05-2009 likh dain jesay hi computer ki date change ho to cell ki date khud ba khud change ho gaye. please aap yeh masal hall kar dain main aap ka bohat mashkoor hoon ga.


My name is muhammand iftikahr sami form
Dubai
3


suppose you are in sheet1 Cell A2 then write this formula =today() .... it will always update whenever you'll open your computer .... If you have any other don't forget to PM me ....
















Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz

8

jsmahender, on Aug 5, 2009 3:22:13 pm BST

Thanks a lot for the poster and replied person.

   
Reply to jsmahender
Ask your question Reply
They need your help