+ Reply to Thread
Results 1 to 4 of 4

Blank cellls if date are equal on larger than todays' date

  1. #1
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Toulouse
    MS-Off Ver
    Excel 2010
    Posts
    141

    Blank cellls if date are equal on larger than todays' date

    Please I have a question ,


    on A3: D10 I have information on C1 a have date and E3:E10 I will input date

    i.e. If the date entered in E3 is the same as or larger than the date on C1 then Blank the entire line A3: D3


    Please any help

    Thank you

  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: Blank cellls if date are equal on larger than todays' date

    In CF rules use this.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Use White color.

    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.

  3. #3
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Toulouse
    MS-Off Ver
    Excel 2010
    Posts
    141

    Re: Blank cellls if date are equal on larger than todays' date

    Quote Originally Posted by kuzna26 View Post
    please i have a question ,


    on a3: D10 i have information on c1 a have date and e3:e10 i will input date

    i.e. If the date entered in e3 is the same as or larger than the date on c1 then blank the entire line a3: D3


    please any help

    thank you
    please where to enter the formula in e3??

  4. #4
    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: Blank cellls if date are equal on larger than todays' date

    In Conditional Formating rules.

+ 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] If formula, if two cells are blank, return blank, if one has a date, subtract todays date
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2014, 12:47 PM
  2. [SOLVED] getting total from column if todays date is equal to or greater than date column
    By peterjb44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-11-2013, 07:43 PM
  3. Replies: 7
    Last Post: 12-08-2013, 06:11 PM
  4. Replies: 8
    Last Post: 02-08-2013, 04:29 AM
  5. Using VB to find a range based on todays date and todays date +30
    By Steve_al in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2009, 09:31 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