+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting based on formulas

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    UK
    MS-Off Ver
    2013
    Posts
    32

    Conditional Formatting based on formulas

    Hi guys,

    Major problem with my brokerage reports.

    We're beginning to see a lot of drops in the report that people aren't noticing.

    What we need....

    In Jan 2013 tab - If calls or profit for the source fall lower than the source performed in Avg 2012 tab, flash red.

    But i can't see to find the right formula.

    I was thinking it's obviously '=B2<'Jan 2013'!B2' but first a function to look up the source within the Averages list.

    I hope this makes sense.

    Your help will be massively appreciated! Need it as soon as possible, thank you all.

    Demo workbook.xlsx
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,798

    Re: Conditional Formatting based on formulas

    In AVg 2012 sheet name the A1:C7 range "sources" (no quotes)
    In Jan 2013 sheet select A2:C7 and apply as CF :
    Please Login or Register  to view this content.

+ 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