+ Reply to Thread
Results 1 to 3 of 3

Conditional Format based on a Conditional Format

  1. #1
    Registered User
    Join Date
    09-08-2009
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    68

    Conditional Format based on a Conditional Format

    I'm almost done with my project, need one last thing!

    I have five fields that have a conditional format applied to them: (see attached)

    Columns J, K, L, N and O. These conditionals highlight if a minimum number is entered. Ex. Minimum pushups for a 30 y/o male is 27, if a 26 is entered it highlights red. The total score (where I need this to perform) is calculated in column Q. It will format red if the total score is below 75 but what I can't figure out is how to make it format if any of the previous minimums have not been met.

    Ex. In cell L4, his crunches were 25 (a automatic failure -- red formatting). Now the total score is above 75 so it calculates as passing (green), but I need it to highlight red regardless because of the minimum not met in cell L4.

    Confusing? Hope not! This is the last part of my project!

    Thanks in advance!
    Attached Files Attached Files
    Last edited by purdue7997; 02-09-2010 at 07:40 PM.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Conditional Format based on a Conditional Format

    Apply the same conditional formats for a failure in L4 to the "total" cell, but change the sequence (order) of priority so that the "failed" conditions are checked before the "total" conditions.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Registered User
    Join Date
    09-08-2009
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    68

    Re: Conditional Format based on a Conditional Format

    Quote Originally Posted by Palmetto View Post
    Apply the same conditional formats for a failure in L4 to the "total" cell, but change the sequence (order) of priority so that the "failed" conditions are checked before the "total" conditions.
    Hmmm, it would be that easy huh? I get so involved with getting it to work, I overlook the simple things. Anyhoo, thanks! I'll solve and post a rep.

+ Reply to Thread

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