+ Reply to Thread
Results 1 to 2 of 2

If Cell value is highest in Range then make cell colour Red

  1. #1
    Registered User
    Join Date
    10-20-2011
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    98

    If Cell value is highest in Range then make cell colour Red

    I have six values in cells A1 to F1

    each time the sheet calculates I want the cell that is highest in value to be interior Coloured Red and the rest No colour.

    Thanks

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: If Cell value is highest in Range then make cell colour Red

    conditional formatting, and custom formula enter
    =A$1=MAX($A$1:$F$1)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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