+ Reply to Thread
Results 1 to 2 of 2

How to format Icon Sets - Making cell F5 to relate to E5

  1. #1
    Registered User
    Join Date
    01-15-2021
    Location
    Norway
    MS-Off Ver
    Newest Excel MacOSBigSurs
    Posts
    1

    How to format Icon Sets - Making cell F5 to relate to E5

    Screenshot 2021-01-15 at 13.15.32.png

    Hi,

    This is my first post here and hopefully I managed to add my image.

    My question is how to I get the icon set in every cell in e.g collum F to show if the Value i e.g F5 is Lower, Higher or the same as in E5?


    Thanks!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,091

    Re: How to format Icon Sets - Making cell F5 to relate to E5

    Icon sets work on the cell in which the value is found only. The only way to do it is duplicate and apply an icon, then hide the contents - you can then make two cells look like one.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. Replies: 1
    Last Post: 03-25-2018, 10:16 AM
  2. [SOLVED] Conditional format using icon sets to compare two columns
    By scottiex in forum Excel General
    Replies: 5
    Last Post: 06-15-2017, 12:26 AM
  3. Replies: 1
    Last Post: 02-17-2017, 10:25 AM
  4. Replies: 0
    Last Post: 09-25-2015, 02:56 PM
  5. [SOLVED] format cells between values -- MANY ranges, similar to icon sets
    By acp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2015, 07:49 PM
  6. [SOLVED] Icon sets for greater than, equal to, and less than for referencing another cell
    By jxsavage in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-28-2013, 06:06 AM
  7. icon sets
    By by1612 in forum Excel General
    Replies: 2
    Last Post: 11-26-2008, 08:24 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