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 :
Excel tips : How to insert date in a cell Show Excel 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¯+...
[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...
Activate Windows XP ShowActivate Windows XP To determine if your version of Windows is activated or windows reminds you to activate the system (normally windows must be activate 30 days after installation). So to activate Windows manually just click on...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
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...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...

1

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

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