+ Reply to Thread
Results 1 to 5 of 5

Can't Get Drop List To Cooperate With Conditional Formatting

  1. #1
    Registered User
    Join Date
    06-05-2017
    Location
    US
    MS-Off Ver
    2013
    Posts
    33

    Can't Get Drop List To Cooperate With Conditional Formatting

    When creating a new rule in conditional formatting I input,

    =IF(AND(AND(AND(OR($B$5<0.011,$B$5>0.0215),$B$2>0,$B$2<400),$B$4>=2,$B$4<=2.499),$B$1=”Galling”),TRUE,IF(AND(AND(AND(OR($B$5<0.011,$B$5>0.0235),$B$2>=400,$B$2<500),$B$4>=2,$B$4<=2.499),$B$1=”Galling”),TRUE,IF(AND(AND(AND(OR($B$5<0.011,$B$5>0.0255),$B$2>=500,$B$2<600),$B$4>=2,$B$4<=2.499),$B$1=”Galling”),TRUE,IF(AND(AND(AND(OR($B$5<0.011,$B$5>0.0275),$B$2>=600,$B$2<700),$B$4>=2,$B$4<=2.499),$B$1=”Galling”),TRUE,IF(AND(AND(AND(OR($B$5<0.011,$B$5>=0.0295),$B$2>=700,$B$2<800),$B$4>=2,$B$4<=2.499),$B$1=”Galling”),TRUE)))))

    but it doesn't highlight the given range red. When I switch the value, "Galling", with a numerical value like 5 it works. I can't figure out how to make the given conditional formatting rule work with the value; "Galling"
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-05-2017
    Location
    US
    MS-Off Ver
    2013
    Posts
    33

    Re: Can't Get Drop List To Cooperate With Conditional Formatting

    Also if anybody knows how to make the font size larger for the selectable options of the drop list. Changing the font size of the cell only affects the selected option.

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Can't Get Drop List To Cooperate With Conditional Formatting

    Add defined name to your attachment first

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Can't Get Drop List To Cooperate With Conditional Formatting

    Fix your quotes around the word Galling.

    Looks like you pasted it from Word into Excel and the quotes are different.
    HTH
    Regards, Jeff

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Can't Get Drop List To Cooperate With Conditional Formatting

    Hi,

    The issue is that you have smart quotes instead of regular quotes- the formula should be
    =IF(AND(AND(AND(OR($B$5<0.011,$B$5>0.0215),$B$2>0,$B$2<400),$B$4>=2,$B$4<=2.499),$B$1="Galling"),TRUE,IF(AND(AND(AND(OR($B$5<0.011,$B$5>0.0235),$B$2>=400,$B$2<500),$B$4>=2,$B$4<=2.499),$B$1="Galling"),TRUE,IF(AND(AND(AND(OR($B$5<0.011,$B$5>0.0255),$B$2>=500,$B$2<600),$B$4>=2,$B$4<=2.499),$B$1="Galling"),TRUE,IF(AND(AND(AND(OR($B$5<0.011,$B$5>0.0275),$B$2>=600,$B$2<700),$B$4>=2,$B$4<=2.499),$B$1="Galling"),TRUE,IF(AND(AND(AND(OR($B$5<0.011,$B$5>=0.0295),$B$2>=700,$B$2<800),$B$4>=2,$B$4<=2.499),$B$1="Galling"),TRUE)))))
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting with Drop Down List
    By beneesetas14 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-29-2015, 11:41 PM
  2. Drop Down List & Conditional Formatting
    By beneesetas14 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2015, 12:34 PM
  3. Conditional Formatting Drop Down List from one column
    By ymcata in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2015, 05:47 AM
  4. Replies: 0
    Last Post: 06-03-2014, 04:21 AM
  5. [SOLVED] Using conditional formatting on a drop down list
    By scottatbuckman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-13-2014, 02:07 PM
  6. Replies: 4
    Last Post: 08-25-2009, 06:00 PM
  7. Conditional Formatting based on a drop down list
    By erica6670 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-15-2008, 12:35 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