Results 1 to 8 of 8

Can't see missing parenthesis in conditional format formula

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365 Version 2501 64-bit
    Posts
    1,465

    Can't see missing parenthesis in conditional format formula

    Attachment has eight possible combinations of Col E and Col F.

    Want conditional formatting to change colour of Col F cell red or green based on following:

    If E="Very high" and F <98%, F format "Red"
    IF E="High" and F<95, F format "Red"
    If E="Significant" and F<85%, F format "Red"
    If E="Low" and F<75%, F format "Red"

    If E="Very high" and F >=98%, F format "Green"
    IF F="High" and F>=95, F format "Green"
    If E="Significant" and F >=85%, F format "Green"
    If F="Low" & E >=75%, F format "Green"

    Putting combined formula in COl N identifies each combination perfectly:

    "=IF(OR(AND(E1="Very High",F1<98%),AND(E1="High",F1<95%),AND(E1="Significant",F1<85%),AND(E1="Low",F1<75%)),"Red",IF(OR(AND(E1="Very High",F1>=98%),AND(E1="High",F1>=95%),AND(E1="Significant",F1>=85%),AND(E1="Low",F1>=75%)),"Green"))"

    But splitting the formula and setting each half to Conditionally Format Col F throw an error message that there is a missing parenthesis?

    "OR(AND(E1="Very High",F1<98%),AND(E1="High",F1<95%),AND(E1="Significant",F1<85%),AND(E1="Low",F1<75%))"
    "OR(AND(E1="Very High",F1>=98%),AND(E1="High",F1>=95%),AND(E1="Significant",F1>=85%),AND(E1="Low",F1>=75%)"

    Problem is I can't see it?

    Any suggestions, pointers or solutions accepted gratefully as ever

    Ochimus
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-10-2016, 11:42 AM
  2. Replies: 5
    Last Post: 09-01-2015, 09:06 PM
  3. [SOLVED] Missing parenthesis or too many argument on a formula
    By dache416 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2014, 01:15 PM
  4. [SOLVED] "Your Formula Missing a Parenthesis"
    By xrajncajnx in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 01:03 PM
  5. [SOLVED] IF statement missing parenthesis in formula
    By Abyrose in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2014, 06:24 PM
  6. [SOLVED] Formula missing parenthesis
    By katieshields in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2014, 03:44 AM
  7. Missing parenthesis
    By docrobo in forum Excel General
    Replies: 3
    Last Post: 10-23-2011, 05:18 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