Results 1 to 3 of 3

Thread: Change Cell Color - Date

  1. 01-26-2016, 11:26 PM #1
    GymWrecker
    GymWrecker is offline
    Junior Member
    Join Date
    Apr 2013
    Posts
    8
    Rep Power
    0

    Question Change Cell Color - Date

    I'm working on a spreadsheet and in the date column, I need the dates to change colors based on Today (). I need the date to turn "blue" when is 90 days from today; turn "orange" when it's 60 days from today; turn "green" when is 30 days from today; and turn red when the date is equal to today or past today... Please advise....

    A1 = 12/31/2015
    A2 = 1/21/2016
    A3 = 1/2/2016
    A4 = 11/15/2015
    A5 = 10/15/2015
    Reply With Quote Reply With Quote
  2. 01-27-2016, 09:00 PM #2
    alansidman
    alansidman is offline
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    13
    Look at this link on conditional formatting and dates

    https://www.ablebits.com/office-addi...matting-dates/
    Alan
    Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
    Like my answer? Click * below
    Database Normalization
    Database Principles
    Pivot Table Tips
    Excel Video Tutorials
    SumProduct Video Tutorial
    DataPig Access Tutorials
    MS Query Tutorial
    SQL Tutorial
    Reply With Quote Reply With Quote
  3. 01-28-2016, 09:26 AM #3
    GymWrecker
    GymWrecker is offline
    Junior Member
    Join Date
    Apr 2013
    Posts
    8
    Rep Power
    0
    Thank you alansidman...!!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Change Color Of Series In A Bar Chart Based On Selection Of DropDowns
    By mrprofit in forum Excel Help
    Replies: 3
    Last Post: 04-18-2014, 12:43 AM
  2. Change Tab Color base on value of cell % Change
    By mrprofit in forum Excel Help
    Replies: 8
    Last Post: 04-16-2014, 10:38 AM
  3. Change Shape Color on MouseOver
    By Ashu2021 in forum Excel Help
    Replies: 1
    Last Post: 01-31-2014, 01:11 PM
  4. Get Return Value Of Active Cell On Change Of Selection Change
    By Safal Shrestha in forum Excel Help
    Replies: 8
    Last Post: 04-16-2013, 02:04 PM
  5. Change in One Cell that Prompts Email to Address in Adjacent Cell
    By jtroi89 in forum Excel Help
    Replies: 1
    Last Post: 08-21-2012, 07:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules