Results 1 to 4 of 4

Adding custom icons to Conditional Formatting

Threaded View

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    Idaho
    MS-Off Ver
    M365
    Posts
    18

    Adding custom icons to Conditional Formatting

    So I do a lot of ranking and rather than waste a column for each and every category I was hoping to find a way to add numbers (rather than icons, arrows, lights, bars, etc) as the conditional formatting. So in the included example sheet I have columns with a variety of information with a corresponding column with the rank of each employee for the category. So what I'd want to do is find a way to do conditional formatting, either through taking the value in a cell or through creating a custom icon set (in this case, a set of numbers) and letting me add the rank as conditional formatting. So I created an example where I did it manually (what I'm trying to avoid) in column F.

    I don't mind doing rank columns and the current set of icons from conditional formatting are fine but it would just be such a time and space saver, along with being more readable, to be able to put the rankings just in the cell with the value. Thanks before hand.
    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. Conditional Formatting - Icons
    By AntG in forum Excel General
    Replies: 2
    Last Post: 07-05-2017, 06:36 AM
  2. [SOLVED] Custom formulas with icons in conditional formatting in Excel 2010
    By Vinniel in forum Excel General
    Replies: 2
    Last Post: 09-24-2012, 09:20 AM
  3. [SOLVED] conditional formatting using icons
    By adil.master in forum Excel General
    Replies: 2
    Last Post: 06-14-2012, 12:24 AM
  4. Conditional Formatting Icons
    By hlb129 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-11-2012, 10:12 AM
  5. Conditional formatting icons help
    By bevelman in forum Excel General
    Replies: 5
    Last Post: 12-21-2010, 10:26 AM
  6. conditional formatting icons
    By gupster in forum Excel General
    Replies: 1
    Last Post: 12-29-2009, 08:52 AM
  7. Adding custom faces-icons to toobar buttons.
    By MarkHG in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-09-2005, 08:06 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