Results 1 to 7 of 7

Conditional Formatting with Formula - have I got the order of precedence wrong?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    839

    Conditional Formatting with Formula - have I got the order of precedence wrong?

    Hi,

    I have set up the attached sample data to test my understanding of conditional formatting (CF).

    The required cell fill colours are shown in column A, the associated CF conditions in column B and the values to be thus formatted in column C.

    I seem to have set up the correct formulae for the CF but all results in column C are formatted as if they're <-0.50, which only one is.

    Can someone please tell me what I'm doing wrong?

    Thanks!
    Attached Files Attached Files
    Last edited by andrewc; 07-05-2019 at 02:53 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 07-05-2019, 11:06 AM
  2. Conditional formatting precedence question
    By lamlam28 in forum Excel General
    Replies: 4
    Last Post: 01-27-2019, 11:50 PM
  3. [SOLVED] What's wrong with this formula for conditional formatting
    By MeijdenB1977 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-02-2018, 09:49 AM
  4. [SOLVED] Conditional formatting and precedence rules
    By KClem in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2015, 02:42 PM
  5. [SOLVED] MAJOR BUG: Excel operator precedence is wrong
    By P Keenan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-23-2006, 09:25 AM
  6. [SOLVED] With formulas does anyone know the order of precedence BOMDAS
    By Samantha in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-14-2005, 04:48 AM
  7. Operator precedence (order of operate) =A1/A2*A3^5-(A1+A2)
    By Masood Shahab in forum Excel General
    Replies: 7
    Last Post: 09-08-2005, 10:05 AM

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