+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting Colors Based on Max Values

Hybrid View

  1. #1
    Registered User
    Join Date
    03-28-2010
    Location
    New York
    MS-Off Ver
    Office 365
    Posts
    57

    Conditional Formatting Colors Based on Max Values

    Hi All,

    I have three cells: [A1], [A2] and [A3]. Each one has a random number which is generated every few seconds automatically by a real-time feed. How do I format so that in [A5] I get an associated color based on where that number is coming from? For example, my formula in [A5] is max(a1,a2,a3). I want A5 to light up in yellow if the value is coming from A1, blue if it is coming from A2 and red if it is coming from a3. I also want to be able to copy and paste this formula to the right and keep the same syntax... for example b5 = max(b1, b2, b3) and the conditional formatting is based on b1, b2, b3.

    Thanks guys!

    Larry

  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 2406
    Posts
    44,662

    Re: Conditional Formatting Colors Based on Max Values

    Hi there. Try this and see if it's what you needed. Drag A5 to the right and the CF will come across, too.
    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

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,108

    Re: Conditional Formatting Colors Based on Max Values

    put in 3 formulas into conditional formatting

    =$A$1=Max($A$1:$A$3) - set to Yellow Fill

    =$A$2=Max($A$1:$A$3) - set to Blue Fill

    =$A$3=Max($A$1:$A$3) - set to Red Fill

    OR as you have the max value in cell A5

    =$A$5=$A$1 - set to Yellow Fill

    =$A$5=$A$2 - set to Blue Fill

    =$A$5=$A$3 - set to Red Fill
    Last edited by etaf; 01-19-2015 at 11:26 AM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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] Fill colors of cells using Conditional formatting based on 3 criteria
    By Sai Prashanth in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-22-2014, 12:39 PM
  2. Highlighting errors based on conditional formatting colors
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-09-2014, 11:22 AM
  3. [SOLVED] Formula based off cell colors / conditional formatting?
    By dsciola in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2013, 03:48 AM
  4. [SOLVED] Conditional Formatting with colors based on date value
    By ashwin639 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2013, 03:52 AM
  5. Replies: 1
    Last Post: 02-15-2013, 09:41 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