Results 1 to 6 of 6

Conditional format based on 4 criteria??

Threaded View

leem Conditional format based on 4... 07-16-2010, 03:15 PM
zbor Re: Conditional format based... 07-16-2010, 03:25 PM
leem Re: Conditional format based... 07-16-2010, 03:35 PM
whatsmyname Re: Conditional format based... 07-20-2010, 12:05 AM
zbor Re: Conditional format based... 07-20-2010, 02:20 AM
whatsmyname Re: Conditional format based... 08-02-2010, 11:10 AM
  1. #1
    Forum Contributor
    Join Date
    11-03-2004
    Posts
    139

    Conditional format based on 4 criteria??

    I'm thinking I want a conditional format but if your knowledge thinks I should achieve my results another way, please let me know

    In cell L5, I have averaged H5:K5. What I would like to do is: if F5 = FT and the result in L5 is < 30 shade blue....if f5 = PT and the result in L5 is > 30 green. I have attached a sample.

    Thanks in advance for your help and knowledge.

    Michelle
    Attached Files Attached Files
    Last edited by leem; 07-16-2010 at 03:35 PM.

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