+ Reply to Thread
Results 1 to 6 of 6

Make Excel mark

  1. #1
    Registered User
    Join Date
    04-16-2017
    Location
    Aarhus, Denmark
    MS-Off Ver
    2010
    Posts
    74

    Make Excel mark

    Ok, hello.

    I wanted to hear if somebody knew how I could make a formula in Excel that could format a cell located in Row C, based on results from values in Row D, E, F.

    (Example is very random, I'm going to use this later, and wanna learn if it can be done)

    But for example in my picture A has 99 green, 57 brown, 61 yellow. So can I make a formula in Excel that automatically would mark the cell A stands in, mark that cell green, because it has most green.

    Again at C, green has 52, brown has 85, yellow has 81, can I automatically make Excel mark the cell with value C, brown.

    Thanks
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by thomexcel; 10-19-2018 at 06:19 PM.

  2. #2
    Registered User
    Join Date
    04-16-2017
    Location
    Aarhus, Denmark
    MS-Off Ver
    2010
    Posts
    74

    Re: Make Excel mark

    What happended with the title, how can I change it?

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Make Excel mark

    To change your title, go back to the first post (your #1), click EDIT and go from there. Its kindaconfusing to find the Thread Title but if you search long enough you'lll figure it out.

    Regarding your request, try this macro :

    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Make Excel mark

    You may try conditional formatting.

    Select D4 to F8 > Press Alt H L N > Use a formula > =D4=MAX($D4:$F4) > Format > change font fill > OK

    Please see attached.
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Make Excel mark

    You need three conditional formatting formulas applied to A4:A8 -
    Match will return 1,2 or 3
    1 for green, 2 for brown and 3 for yellow. Checking for green:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

  6. #6
    Registered User
    Join Date
    04-16-2017
    Location
    Aarhus, Denmark
    MS-Off Ver
    2010
    Posts
    74

    Re: Make Excel mark

    Thanks everyone I will ASAP try it out

+ 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. Check mark to make text appear?
    By QuantEdge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2018, 07:40 AM
  2. Replies: 2
    Last Post: 10-28-2013, 03:52 PM
  3. Excel: How do I type a letter in a column and make a check mark a.
    By BauerY in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-15-2012, 11:46 PM
  4. How to make a one point conditional mark in a column
    By tomjoe in forum Excel General
    Replies: 2
    Last Post: 01-08-2011, 06:29 PM
  5. [SOLVED] Need to make a mark up table with more than 7 if statements
    By Digace in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-15-2006, 08:15 AM
  6. [SOLVED] How do I make a check mark?
    By kentrks in forum Excel General
    Replies: 2
    Last Post: 09-07-2005, 09:05 PM
  7. How do I make a water mark on an excel spreadsheet?
    By Lelindar in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-05-2005, 10:06 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