+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting - Highlight cells that are greater than the value of a cell.

  1. #1
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    554

    Smile Conditional Formatting - Highlight cells that are greater than the value of a cell.

    Dear Friends,

    I need to apply a Formula to apply in conditional formatting, which should highlight the cells that are more than 07:00 hrs (i.e. the qualifying data is mentioned in W2).

    The sample data is given here (The below mentioned values are incoming timings of employees):

    Please Login or Register  to view this content.
    Request your kind help.
    Good friends are hard to find, harder to leave, and impossible to forget.

    acsishere.

  2. #2
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Mauritius
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Conditional Formatting - Highlight cells that are greater than the value of a cell.

    What do you mean by qualifying data inW2? I can't see anything in W2.

  3. #3
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    554

    Re: Conditional Formatting - Highlight cells that are greater than the value of a cell.

    Dear Sir,

    The range, in which the conditional formatting is to be applied, is from A2:M11. Then the exact attendance time is mentioned in W2.

    Now, I need to APPLY A CONDITIONAL FORMATTING TO KNOW THAT whether each employee's in-time is exceeded or not when compared with the time mentioned in W2.

    Hope, now it is clear.

  4. #4
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,486

    Re: Conditional Formatting - Highlight cells that are greater than the value of a cell.

    Post a sample sheet please
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,229

    Re: Conditional Formatting - Highlight cells that are greater than the value of a cell.

    Try this...

    1. highlight the range you want to apply the conditional formatting to A2:M11
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =A2>=$W$2
    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

  6. #6
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    554

    Smile Re: Conditional Formatting - Highlight cells that are greater than the value of a cell.

    Dear sir,

    Nicely working. But, I am facing one problem. In cell W2: presently I entered: 07.00. The conditional formula is applied for the range and working nicely.

    But, when I changed 07.00 to 07.35 or something else, then, only 07 was considered and the numbers beyond decimal was not considered.

    Is there a solution?

+ 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: 5
    Last Post: 07-03-2013, 12:51 AM
  2. Conditional formatting - highlight range of cells when it equals a cell
    By kingkong321 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 05:13 AM
  3. Conditional Formatting - Highlight All Cells in Row If One Cell Row Contains
    By trojo805 in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 11-09-2010, 07:01 PM
  4. Conditional Formatting Greater than surrounding Cells
    By tmiller in forum Excel General
    Replies: 1
    Last Post: 03-30-2007, 12:15 PM
  5. Conditional formatting for the greater of 7 cells
    By guest123 in forum Excel General
    Replies: 8
    Last Post: 01-15-2007, 01:39 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