Results 1 to 5 of 5

Conditional formatting based on maximum deviation in range

Threaded View

  1. #1
    Registered User
    Join Date
    09-28-2017
    Location
    Ontario
    MS-Off Ver
    Excel for Microsoft 365 MSO (version 2311)
    Posts
    11

    Conditional formatting based on maximum deviation in range

    I have a range of cells containing measurements, formatted as fractions to 2 digits: 68 3/16, 67 7/8, 67 3/4, 67 15/16, etc. I am trying to add conditional formatting that will analyze and highlight the range based on 3 scenarios

    Green: difference from largest to smallest numbers is between (and including) 0 & 1/4
    Yellow: difference from largest to smallest numbers is between 1/4 and 1/2
    Red: difference from largest to smallest is greater than 1/2

    I have multiple sets of ranges, independent of one another by a blank row right now. Can I add some kind of IF statement for the CF based on if there is a number in the cell above or below to set the range, or how can I apply this to the entire column?

    Thanks in advance!
    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: 3
    Last Post: 10-31-2013, 04:50 AM
  2. Replies: 4
    Last Post: 10-19-2013, 08:58 AM
  3. [SOLVED] Conditional Formatting based on maximum date to another column
    By farrukh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2013, 09:37 AM
  4. Replies: 3
    Last Post: 08-13-2013, 09:44 AM
  5. Conditional Formatting via VBA: Change formatting in range based on value of each cell
    By ralphjmedia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2013, 10:37 AM
  6. [SOLVED] Conditional Formatting for Standard Deviation
    By OverKnight in forum Excel General
    Replies: 4
    Last Post: 01-16-2013, 07:08 PM
  7. [SOLVED] Conditional formatting based on deviation values.
    By pyol17 in forum Excel General
    Replies: 6
    Last Post: 10-04-2012, 03:04 AM
  8. Conditional Formatting - Grey Out and Lock A range based on a cell value in that range
    By Excelgnome in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2012, 07:31 PM

Tags for this Thread

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