Results 1 to 11 of 11

formating according to how far away a value is from ideal value

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2019
    Location
    zurich
    MS-Off Ver
    Office 2019
    Posts
    15

    Question formating according to how far away a value is from ideal value

    Formating according to how far away a value is from an ideal value. E.g. ideal value is 100, the lowest value 10 should become dark red, 20 ligther red, 30 maybe orange etc. the nearer it gets to the ideal value the greener (or less red or whatever) it becomes. The same for the other direction for numbers over 100.
    Last edited by itge13; 04-30-2019 at 10:40 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. What's the ideal way to represent this data in a chart?
    By Katie620 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-11-2018, 08:32 PM
  2. [SOLVED] An ideal graph that summarizes the situation
    By asifamanulla in forum Excel General
    Replies: 2
    Last Post: 12-18-2017, 01:11 PM
  3. Finding Ideal Schedule Times
    By mike182 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-14-2017, 03:37 AM
  4. Vlookup for multiple resulf
    By mic1412 in forum Excel General
    Replies: 4
    Last Post: 07-22-2017, 01:59 AM
  5. stumped on ideal layout
    By tammym in forum Excel General
    Replies: 1
    Last Post: 07-06-2012, 08:21 PM
  6. use an ideal function to MATCH
    By iliasark in forum Excel General
    Replies: 10
    Last Post: 06-25-2012, 02:14 PM
  7. Ideal Tracking Log Help
    By kblaine in forum Excel General
    Replies: 2
    Last Post: 07-28-2011, 08:50 AM

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