+ Reply to Thread
Results 1 to 11 of 11

Highlighting blank cells based on a criteria

  1. #1
    Registered User
    Join Date
    08-31-2013
    Location
    Kuwait
    MS-Off Ver
    Microsoft office 365
    Posts
    87

    Highlighting blank cells based on a criteria

    Dear All,

    I have been working on a sheet that has a start, finish & a completion date. Now, if the completion date is empty , i require the cells in the dates column to be highlighted up-to today's date until a date is entered in the completion date cell.

    Can anyone please help me out ?

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Highlighting blank cells based on a criteria

    probably, but without a sample your answer will be slow look at the banner at the top of the page and attach a sample

    Otherwise work out conditional formatting yourself, as that is the area of excel to use
    https://www.excel-easy.com/data-****...ormatting.html

  3. #3
    Registered User
    Join Date
    08-31-2013
    Location
    Kuwait
    MS-Off Ver
    Microsoft office 365
    Posts
    87

    Re: Highlighting blank cells based on a criteria

    Please see the attached file
    Attached Files Attached Files

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Highlighting blank cells based on a criteria

    May be put

    =$E$3>F2 in conditional formatting
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  5. #5
    Registered User
    Join Date
    12-03-2012
    Location
    CHENNAI , INDIA
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Highlighting blank cells based on a criteria

    Hi ,

    Try this :

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


    Select the range F3:BW3 before you create this rule and apply it.

    Narayan

  6. #6
    Registered User
    Join Date
    08-31-2013
    Location
    Kuwait
    MS-Off Ver
    Microsoft office 365
    Posts
    87

    Re: Highlighting blank cells based on a criteria

    Thanks the formula worked. One question though, if i want the cells to be white in color before the start date, will that be possible ?. I am also trying.

  7. #7
    Registered User
    Join Date
    12-03-2012
    Location
    CHENNAI , INDIA
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Highlighting blank cells based on a criteria

    Quote Originally Posted by simran555 View Post
    Thanks the formula worked. One question though, if i want the cells to be white in color before the start date, will that be possible ?. I am also trying.
    Hi ,

    Which formula worked ? To whom is this addressed ?

    Narayan

  8. #8
    Registered User
    Join Date
    12-03-2012
    Location
    CHENNAI , INDIA
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Highlighting blank cells based on a criteria

    Hi ,

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


    Narayan

  9. #9
    Registered User
    Join Date
    08-31-2013
    Location
    Kuwait
    MS-Off Ver
    Microsoft office 365
    Posts
    87

    Re: Highlighting blank cells based on a criteria

    please check and i require the sheet to show me blank cell before the start date.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    12-03-2012
    Location
    CHENNAI , INDIA
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Highlighting blank cells based on a criteria

    Hi ,

    Did you try the formula mentioned in post #8 ?

    I have put in that formula in your file. Check it out and give feedback.

    Narayan
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    08-31-2013
    Location
    Kuwait
    MS-Off Ver
    Microsoft office 365
    Posts
    87

    Re: Highlighting blank cells based on a criteria

    solved. Thanks a lot

+ 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] Highlighting blank cells
    By langham in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-15-2019, 06:45 AM
  2. [SOLVED] Concatenate Cells Without Blank Cell Based On Criteria
    By chaitanyapandya in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-14-2017, 03:53 AM
  3. Counting blank cells based on non adjacent criteria
    By FrankMcG in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-30-2013, 04:47 PM
  4. [SOLVED] Highlighting blank cells
    By Ellen 2Excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-05-2013, 08:53 PM
  5. Highlighting cells based off multiple criteria
    By mstieler in forum Excel General
    Replies: 0
    Last Post: 02-20-2013, 07:26 PM
  6. Highlighting a Cell, based on value / blank.
    By robert_shindorf in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-29-2008, 07:42 PM
  7. Replies: 6
    Last Post: 08-28-2005, 05:05 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