+ Reply to Thread
Results 1 to 9 of 9

Conditional formatting for the greater of 7 cells

  1. #1
    Registered User
    Join Date
    01-03-2007
    Posts
    6

    Question Conditional formatting for the greater of 7 cells

    Hi,

    I have a column of 7 cells, which return a value which will be between 0 and 400, but the cells themselves are formulae (e.g. G13 "=(C13*C$12)+(D13*D$12)+(E13*E$12)+(F13*F$12)").

    I would like to conditionally format the column so that all cells in the column remain one colour (I happen to be using gold), but that whichever cell returns the greatest value of the 7 is formatted green.

    Is this possible, or am I going to have to do it manually?

    Many thanks!

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    3,993
    Hi,

    Format Conditional Formatting
    Formula Is
    Please Login or Register  to view this content.
    Format Patterns Green
    and use Format Painter to copy format to all seven cells ...
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    01-03-2007
    Posts
    6

    Not sure this works..

    Hi,
    Thanks very much for your reply. I tried this, and it does not work. Could this be because the actual value of the cells is a formula which returns a number, not a number itself? (i.e. "=(C13*C$12)+(D13*D$12)+(E13*E$12)+(F13*F$12)")
    Thanks!

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    3,993
    Hi,

    I do no think this would be the problem ...
    Do you mind uploading a zipped copy of your worsksheet, for a precise answer ...?

  5. #5
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    Conditional formatting is based on the value of a cell, whether that value is generated by a formula or not is not relevant.

    Which is your range of 7 cells? Do you only have one range or the same thing in multiple columns?

  6. #6
    Registered User
    Join Date
    01-03-2007
    Posts
    6

    Here's the file

    Hi, here's the file. I hope I'm not being really stupid!
    Thanks
    Attached Files Attached Files

  7. #7
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    3,993
    Hi,

    Attached is your spreadsheet ...
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    01-03-2007
    Posts
    6

    Smile Thanks!

    Awesome - thanks ever so much!

  9. #9
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    3,993
    Glad your problem is fixed ...

    Thanks for the feedback

+ 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