+ Reply to Thread
Results 1 to 7 of 7

easy q - conditional formatting

  1. #1
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    easy q - conditional formatting

    I am trying to use conditional formatting within a column, filling the cells in with bright red IF the date is less than "today" and the cell is not blank.

    I understand =today() and <>"" but for whatever reason this is giving me problems.. dates that are not supposed to be in the range are highlighted.. or only blank dates are highlighted.. etc.

    I originally wanted to use this within a filtered range but reverted back to non filtered just to figure it out. i know its something simple. Please help haha

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: easy q - conditional formatting

    Perhaps something like this?

    =AND(A2<TODAY(),A2<>"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Re: easy q - conditional formatting

    Yeah, that was the first one I used - but it skips over dates, highlights random blank cells and highlights days next month too..

    I formatted to left indent, bottom and also date XX/XX/XXXX but no dice. I dont get it.

  4. #4
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Re: easy q - conditional formatting

    So i just realized something. It looks like the rule is highlighting 1 cell ABOVE the match its looking for, so it looks like it is mismatching. (I had selected the column prior to using conditional formatting.. ) I think I can figure it out from here though - but hey, something to look out for I suppose! haha, thank you for your help

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: easy q - conditional formatting

    1. Try and avoid using full-column references in CF, it can tend to slow your file down.
    2. make sure that the row ref if your formula matches the row ref from your range
    3. Make sure your dates really are dates, and not text that looks like dates (test with =ISNUMBER(cell-ref)...FALSE indicates text)

  6. #6
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Re: easy q - conditional formatting

    Actually no - still not sure why it is highlighting the cell above the one it should..

  7. #7
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    Re: easy q - conditional formatting

    appreciate the tips, I figured it out, will mark as solved. Thanks again.

+ 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. [SOLVED] Conditional formatting, easy question
    By johanna0507 in forum Excel General
    Replies: 7
    Last Post: 11-01-2013, 10:56 AM
  2. [SOLVED] Easy 'Conditional Formatting' Question For You Experts
    By yakabod in forum Excel General
    Replies: 5
    Last Post: 12-04-2012, 12:21 PM
  3. Replies: 5
    Last Post: 10-04-2012, 08:56 PM
  4. Easy table formatting-
    By kmurphy372 in forum Excel General
    Replies: 0
    Last Post: 09-05-2012, 03:05 PM
  5. Easy table formatting-
    By kmurphy372 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-05-2012, 02:36 PM
  6. Simple/Easy Conditional Formatting Question - except for me
    By bmoore_namaste in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2012, 01:49 PM
  7. Easy conditional formatting question
    By BartG in forum Excel General
    Replies: 1
    Last Post: 09-26-2007, 11:34 AM
  8. Very Easy Formatting Question
    By Lidos in forum Excel General
    Replies: 5
    Last Post: 08-20-2007, 05:33 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1