+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting, multiple rules

  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    Phoenix
    MS-Off Ver
    Excel 2007
    Posts
    2

    Conditional Formatting, multiple rules

    Lets say I have a set of data and I am creating a few sets of rule that I want to use conditional formatting for. The only rule I can't figure out is how to format for an in between figure. For instance, I want anything >=70 and <80 to be formatted a certain way. How would this rule get entered?

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Conditional Formatting, multiple rules

    hi jsch08, welcome to the forum. select the range you want to apply to (say from A2:A10)
    go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
    =AND(A2>=70,A2<80)

+ 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