+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting with dates

Hybrid View

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Newcastle
    MS-Off Ver
    2010
    Posts
    25

    Conditional Formatting with dates

    I'm trying to get dates within a column on a table highlighted depending on their value.

    I know how to do this using today's date, but I am having issues in using a separate set date as the parameter.

    For example;

    I want all values in a table in =K7:K72 that are more than 30 days older than a value set in A3 to be highlighted red.

    This should be quite easy, but every time I enter anything the whole column changes colour when this is incorrect.

    Cheers in advance

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Conditional Formatting with dates

    Did you tried in CF rules?

    Formula: copy to clipboard
    =$k7>=$a$3+30


    How can you use Conditional Formating.

    --In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ 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. Replies: 4
    Last Post: 08-29-2013, 11:23 AM
  2. [SOLVED] Conditional Formatting of: dates within 1 month and dates before today.
    By Luke Smith in forum Excel General
    Replies: 5
    Last Post: 06-18-2013, 07:29 AM
  3. [SOLVED] Conditional Formatting Dates
    By AmyRachel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-19-2013, 11:13 AM
  4. Dates and conditional formatting.
    By Ducatisto in forum Excel General
    Replies: 4
    Last Post: 03-08-2011, 03:43 PM
  5. Dates in Conditional Formatting help!!!
    By Corey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-27-2006, 05:10 AM

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