+ Reply to Thread
Results 1 to 3 of 3

Formula that turns cell a color based on criteria

  1. #1
    Registered User
    Join Date
    06-20-2016
    Location
    Wisconsin, USA
    MS-Off Ver
    365 ProPlus
    Posts
    44

    Formula that turns cell a color based on criteria

    Hello,

    I have some cells that contain dates in the past and I was wondering if there was an excel function that would turn that cell with the date in it red if that date was more than 30 days in the past.

    I have attached a sample workbook.

    Thank you
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Formula that turns cell a color based on criteria

    Select Column B

    Click on the Conditional Formatting button on the Home Tab in Excel, and select "Highlight Cell Rules", and then "Less Than"

    In the textbox on the Left, type =TODAY()-30

    Select the format you want in the other box if necessary

    Click OK and done!
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Registered User
    Join Date
    06-20-2016
    Location
    Wisconsin, USA
    MS-Off Ver
    365 ProPlus
    Posts
    44

    Re: Formula that turns cell a color based on criteria

    Awesome! Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cell Fill Color based on multiple criteria
    By Mr Teafortwo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 02:00 PM
  2. Replies: 2
    Last Post: 04-24-2014, 07:02 AM
  3. Color Date Cell in Column based on Criteria
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2013, 02:21 PM
  4. [SOLVED] Color cell based on date criteria
    By RonNCmale in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2012, 02:26 AM
  5. Color Fill Cell Based on Criteria
    By frankee_gee in forum Excel General
    Replies: 3
    Last Post: 04-24-2008, 02:55 PM
  6. [SOLVED] Loop criteria based on cell value and color
    By Jim at Eagle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2006, 09:00 PM
  7. [SOLVED] I am trying to color fill a cell based on specific criteria
    By jglen in forum Excel General
    Replies: 1
    Last Post: 05-27-2005, 01:05 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1