Results 1 to 14 of 14

conditional formatting with multiple rows

Threaded View

  1. #1
    Registered User
    Join Date
    03-01-2011
    Location
    Perth,Australia
    MS-Off Ver
    Excel 2003
    Posts
    7

    Question conditional formatting with multiple rows

    I have a spreadsheet with which users register the results of random breathalyzer tests.
    I have it set up so that if the result is ever FAIL, the text goes red
    In column B is the name of the person tested, column D is the pass/fail.
    how would I go about highlighting the cell if a person has failed twice or more?
    can conditional formatting do this? or will I need a macro?
    Last edited by tutigan; 03-02-2011 at 01:35 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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