Results 1 to 7 of 7

Conditional Formatting with multiple criteria

Threaded View

ahalliwell Conditional Formatting with... 12-21-2016, 12:07 PM
6StringJazzer Re: Conditional Formatting... 12-21-2016, 12:42 PM
ahalliwell Re: Conditional Formatting... 12-22-2016, 05:44 AM
ahalliwell Re: Conditional Formatting... 12-22-2016, 05:55 AM
AliGW Re: Conditional Formatting... 12-22-2016, 06:04 AM
ahalliwell Re: Conditional Formatting... 12-22-2016, 07:32 AM
AliGW Re: Conditional Formatting... 12-22-2016, 08:04 AM
  1. #1
    Registered User
    Join Date
    11-25-2016
    Location
    Warrington
    MS-Off Ver
    2010
    Posts
    60

    Conditional Formatting with multiple criteria

    Hello!

    I hope this is in the correct section.

    I am hoping you can help me with some conditional formatting on some cells of mine.

    Below is my spread sheet, the formatting needs to be on the sheets named with a month, on each month at the bottom of the sheet there is a table with the title "Pause Data For Yesterday".

    Within this table I have "Pause Type" and "Time in Pause".

    I want my conditional formatting to highlight the "Time in pause" box read with bold white writing when the word "30 Minute Lunch" in the column named "pause Type" is present and when the column "Time in pause" is greater than 00:30:30

    I have tried using the =AND function and the =SEARCH function in the conditional formatting but I cant get it to work.

    Can anyone help?
    Attached Files Attached Files

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 over multiple cells with multiple criteria validator
    By effendrew in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-31-2015, 05:05 PM
  2. Replies: 5
    Last Post: 12-28-2012, 02:06 PM
  3. [SOLVED] Conditional Formatting with multiple criteria
    By RLSaSSy in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-14-2012, 10:52 AM
  4. Conditional Formatting with multiple AND/OR criteria
    By camdameron in forum Excel General
    Replies: 7
    Last Post: 11-02-2010, 02:03 PM
  5. conditional formatting, multiple criteria
    By Lara in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2006, 02:20 PM
  6. [SOLVED] conditional formatting, multiple criteria
    By Lara in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2006, 01:45 PM
  7. Multiple Criteria for Conditional Formatting
    By Dave Y in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-21-2006, 02:45 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