+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting based on result of formula within the same cell

  1. #1
    Registered User
    Join Date
    05-11-2008
    MS-Off Ver
    2010
    Posts
    91

    Conditional formatting based on result of formula within the same cell

    Is there a way to do conditional formatting where depending on what the result of the cell is, it will highlight the cell a specific color? For example I have 2 lists that I am doing a vlookup on, one is an actual listing and one is a target listing. I am using the iferror formula in my vlookup to first look in the actual list to return a result. If there is an error on the actual list, then it will return whatever is on the target list. I need to know whether or not I am using the actual listing or target listing via highlighting the cell that has the vlookup formula in it. I have attached an example. For example, on the Summary tab in row 6, the type is "a" so the value of 100 is from the Actual List in the Listing tab. If the type is "y" like in row 8 then the value will be 140 which is from the Target List in the Listing tab. I need the cells in column B to be highlighted if the corresponding value is from the Actual List and not highlighted if the corresponding value is from the Target List (I have manually highlighted them as an example). Is this possible to do with conditional formatting? TIA!
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Conditional formatting based on result of formula within the same cell

    Use this CF formula for the range shown in your example.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-11-2008
    MS-Off Ver
    2010
    Posts
    91

    Re: Conditional formatting based on result of formula within the same cell

    Perfect that worked out great. Thanks!

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Conditional formatting based on result of formula within the same cell

    You're welcome! Thanks for the rep, and thanks for marking your thread Solved!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 09-16-2014, 05:50 PM
  2. Conditional formatting - more than 3 conditions - result based on another cell
    By Mostlygood in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-07-2013, 10:07 AM
  3. [SOLVED] Conditional Formatting to evaluate formula result not cell value
    By snoproladd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-16-2012, 11:11 PM
  4. conditional formatting to change colour of cell based on formula result
    By gideong in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-15-2009, 09:35 AM
  5. [SOLVED] conditional formatting based on another cells formula result
    By kstarkey in forum Excel General
    Replies: 3
    Last Post: 10-05-2005, 05:05 PM

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