Results 1 to 4 of 4

conditional formatting

Threaded View

xceed conditional formatting 03-17-2011, 12:06 AM
DonkeyOte Re: conditional formatting 03-17-2011, 04:13 AM
zzmxy Re: conditional formatting 03-17-2011, 11:45 PM
xceed Re: conditional formatting 03-17-2011, 10:30 PM
  1. #1
    Registered User
    Join Date
    03-16-2011
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    conditional formatting

    Hello,
    I am a not very experienced user of excel 2007.
    I have a row of figures in a table, some cells may be blank. I total the highest 3. With help from past forum threads I have achieved this.
    I now want to conditionally format these 3. Ideally I would prefer to format the non blank cells that are not included in the best 3.
    The problem with using the standard selection of largest is that if the 4th highest is the same as the third, 4 are highlighted (1st row in attached).
    Specifying bottom no. is worse due to empty cells (row 2).
    My formula for totalling does not work when inserted into conditional formatting.
    Some help much appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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