+ Reply to Thread
Results 1 to 3 of 3

Highlighting certain numbers in a column of numbers

  1. #1
    Registered User
    Join Date
    11-03-2020
    Location
    germany
    MS-Off Ver
    365
    Posts
    46

    Highlighting certain numbers in a column of numbers

    Hi all,
    I have list of scores and positions. The "Scores" in Column A are sorted out into "Positions" in Column B

    I would now like to highlight Positions 1,2,3,4 and 5 with a colour like yellow.
    Scores are sorted by the formula =IF(A3=0;"";COUNTIFS($A$3:$A$17;">0";$A$3:$A$17;"<"&A3)+1)

    Thx in advance

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Highlighting certain numbers in a column of numbers

    Use conditional formatting

    =B5<=5

    apply to the data range. I reused your last sheet.

    You should always supply a sample sheet. People understand words and sentences differently. It's much easier with a sheet (and defintely not a picture of a sheet) to play with.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    11-03-2020
    Location
    germany
    MS-Off Ver
    365
    Posts
    46

    Re: Highlighting certain numbers in a column of numbers

    Hi Glen,
    Works a treat....thx

+ 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. Copying Range Of Numbers Deletes Previously Copied Numbers In Column
    By Genus Max in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-29-2020, 01:48 AM
  2. [SOLVED] Highlighting numbers that appear more than 3 times
    By Spotniq in forum Excel General
    Replies: 9
    Last Post: 01-15-2020, 03:52 AM
  3. Replies: 6
    Last Post: 05-30-2016, 04:18 AM
  4. Replies: 4
    Last Post: 05-08-2014, 09:43 PM
  5. Replies: 15
    Last Post: 05-24-2013, 11:01 AM
  6. [SOLVED] Validating missing numbers (highlighting comparison column)
    By LeeliCon in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-22-2012, 07:13 PM
  7. automatically highlighting numbers 0 and 1
    By lau260x in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2008, 03:52 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