+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting with reference to two columns

  1. #1
    Registered User
    Join Date
    09-01-2013
    Location
    qatar
    MS-Off Ver
    Excel 2013
    Posts
    2

    Conditional Formatting with reference to two columns

    Hi,
    I am a new member and I need someone’s help urgently please
    I am trying to put conditional formatting on the attached spreadsheet and struggling to do that
    The dates in column G and J are based on a condition format already in place, the columns H and K corresponds to the due dates the notices to be issued by
    What I am struggling to do is
    1) If the notice is issued well before the due date or on the due date(I mean within time), the cell in G and J should be blank
    2) The notices which are past 7 days reflect in red
    3) The notices which are 7 days ahead in orange
    Please anyone who can help?
    regards
    Attached Files Attached Files
    Last edited by ash210; 09-02-2013 at 02:18 AM.

  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,972

    Re: Urgent help plsssssssssss

    Administrative Note:
    • We would love to help you with your query, but first, before we can proceed…
    • Please see Forum Rule #1 about proper thread
    • Please PM me when complete and this post will be removed which will reset the replies to zero…

      To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title
    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
    Registered User
    Join Date
    09-01-2013
    Location
    qatar
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Conditional Formatting with reference to two columns

    can anyone help please?

+ 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. urgent
    By fclcv in forum Excel General
    Replies: 1
    Last Post: 09-29-2012, 11:31 PM
  2. Need urgent help with error! Urgent!
    By heidenman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2009, 04:31 AM
  3. [SOLVED] a very urgent help in VBA
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2006, 08:20 AM
  4. [SOLVED] Urgent-Urgent VBA LOOP
    By Jeff in forum Excel General
    Replies: 0
    Last Post: 10-06-2005, 01:05 PM
  5. Please Help (Urgent)
    By jyang in forum Excel General
    Replies: 0
    Last Post: 08-07-2005, 08:23 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