+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting - How to colour code based on range

  1. #1
    Registered User
    Join Date
    01-24-2016
    Location
    Leeds
    MS-Off Ver
    14.3.6 for mac
    Posts
    12

    Conditional Formatting - How to colour code based on range

    Hi,

    Hoping someone can help.

    It might sound like a silly question but I am looking to format a column using the 3 colour scale and can't seem to get the ranging right.

    The column contains 0 decimal percentages E.G:

    89%
    72%
    65%
    32%

    I want to conditionally format this column so anything >80% is green, anything <80% but >60% is yellow and anything <=60% is red

    Can't figure it out - too used to the simplicity of Google Sheets I think!

    Cheers in advance,

    Ian

  2. #2
    Registered User
    Join Date
    01-24-2016
    Location
    Leeds
    MS-Off Ver
    14.3.6 for mac
    Posts
    12

    Re: Conditional Formatting - How to colour code based on range

    Turns out I didn't look hard enough! Apologies

+ 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. [SOLVED] conditional formatting range with colour scale
    By jstk886 in forum Excel General
    Replies: 2
    Last Post: 10-29-2013, 03:00 PM
  2. [SOLVED] Conditional Formatting based on Colour Priority
    By TommyK25 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-06-2013, 09:51 AM
  3. [SOLVED] Conditional Formatting (?) based upon another cells colour
    By bellevue in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-09-2012, 04:27 AM
  4. VBA Code Conditional Formatting based on number range
    By LMS0214 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2011, 03:08 PM
  5. conditional formatting based on cell colour
    By nervous_pilchard in forum Excel General
    Replies: 0
    Last Post: 07-12-2011, 05:29 AM
  6. Replies: 5
    Last Post: 10-03-2009, 04:31 PM
  7. Help with conditional formatting:colour code
    By Vipulparbat in forum Excel General
    Replies: 1
    Last Post: 08-30-2006, 08:53 AM
  8. conditional formatting:How can I rate a cell 1-5 and colour code it?
    By treetop40 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2005, 08:05 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