+ Reply to Thread
Results 1 to 2 of 2

conditional formatting based on criteria

  1. #1
    Forum Contributor
    Join Date
    07-15-2015
    Location
    Kolkata
    MS-Off Ver
    2010 & 2013
    Posts
    303

    conditional formatting based on criteria

    Hi i need help to do conditional formatting based on criteria in "Report-Daily" sheet. Criteria is attached
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: conditional formatting based on criteria

    you want to colour column G and H
    based on the table

    Criteria
    Status TOS (Time on System)
    Present < 8:00:00 RED
    Present > = 8:00:00 GREEN
    Half Day < 4:00:00 RED
    Half Day > = 4:00:00 GREEN

    But you sample does not show those results
    G9 is half day > 4 - so should be green

    For Green
    =OR(AND($C5="present",G5 > = TIME(8,0,0),$C5 < > ""),AND($C5="half day",G5 > = TIME(4,0,0),$C5 < > ""))

    For RED
    =OR(AND($C5="present",G5 < TIME(8,0,0),$C5 < > ""),AND($C5="half day",G5 < TIME(4,0,0),$C5 < > ""))
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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 based on 3 criteria
    By rz6657 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2018, 06:41 PM
  2. [SOLVED] Conditional formatting based on criteria
    By fscutaro in forum Excel General
    Replies: 7
    Last Post: 12-08-2015, 03:31 PM
  3. [SOLVED] Conditional Formatting - Based on Criteria
    By mlbdc2012 in forum Excel General
    Replies: 2
    Last Post: 02-03-2015, 05:50 PM
  4. [SOLVED] Conditional Formatting Based on Two Criteria (Using VBA)
    By macrorookie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2014, 07:19 PM
  5. [SOLVED] Conditional formatting based on two criteria
    By Brumbot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-24-2013, 05:44 AM
  6. [SOLVED] Conditional Formatting based on 2 criteria
    By SantosJ in forum Excel General
    Replies: 2
    Last Post: 05-23-2012, 05:11 AM
  7. Using conditional formatting based on certain criteria
    By sophy_1402 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2011, 07:32 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