+ Reply to Thread
Results 1 to 3 of 3

Conditional Formating Formulae to Make it easier?

  1. #1
    Registered User
    Join Date
    05-16-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    15

    Conditional Formating Formulae to Make it easier?

    Hi,

    I have a spreadsheet involving sales targets and performance, please refer to the attached sample spredsheet,

    Basically each for each sales memeber they have a target for the month and then the actual performance. I would like the performance figure to be highlight in Green fill if they best the corresponding target and Red if below.

    I would like to avoid having to go into each and every cell and set up the conditional formating for what could actually done manually using formatting.

    Anyway, the attacched sample should clarify, if anyone has any ideas it would be greatly appreciated,

    Cheers
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Conditional Formating Formulae to Make it easier?

    On row 3, two rules

    =AND(ISNUMBER(B3),B3<B2) >> Red

    =AND(ISNUMBER(B3),B3>B2) >> Green
    HTH
    Regards, Jeff

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,228

    Re: Conditional Formating Formulae to Make it easier?

    Hi ngor3431,

    See if the attached works for you. Look at the Conditional Formatting in Row 3. It is using the year total divided by 12.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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