+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting based on formula used.

  1. #1
    Forum Contributor
    Join Date
    03-05-2015
    Location
    norwich
    MS-Off Ver
    365
    Posts
    107

    Conditional formatting based on formula used.

    Quick question,

    I there a way to conditionally format a cell based on the the part of a formula used?

    For example using an if formula

    =IF(A1=B1,A1-B1,B1-A1)

    Is it possible to condionally format the cell because the TRUE formula was used or if the FALSE was used?

    The above is a simplified version of the problem I have. There is no way of checking based on the result which formula has been used because the results are so comparable. I'm looking for conditionally formatting based on the formula and not the result.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Conditional formatting based on formula used.

    Not sure if I understand, but based on your example wold be enough to use this:=A1=B1 for TRUE as well as FALSE
    Click the * to say thanks.

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Conditional formatting based on formula used.

    The first thought that springs to my mind is to generate the formula string with =FORMULATEXT( < cell containing formula > )

    Does that start things in the right direction?
    Dave

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: Conditional formatting based on formula used.

    In your example you would use as a CF formula:

    =A1=B1

    for the TRUE outcome of your IF formula (colour accordingly), and:

    =A1<>B1

    for the FALSE (use a different colour).

    Hope this helps.

    Pete

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Conditional formatting based on formula used.

    I'm looking for conditionally formatting based on the formula and not the result.
    I have been focusing on that part. Will you please expand on its meaning?

+ 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. [SOLVED] Conditional formatting based on the formula
    By Eduards in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-06-2018, 03:12 PM
  2. [SOLVED] Formula based on Conditional Formatting
    By kimmycoop910 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-22-2016, 12:56 AM
  3. [SOLVED] Conditional formatting based on a formula value
    By Journeyman3000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-29-2014, 08:02 PM
  4. [SOLVED] Help with Conditional Formatting Based on Formula
    By rosboy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-27-2013, 12:29 PM
  5. [SOLVED] Conditional Formatting based on a Formula
    By bbyrne in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-01-2012, 08:47 PM
  6. [SOLVED] Conditional Formatting - Formula based
    By Nick Danger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-10-2005, 02:05 PM
  7. [SOLVED] Conditional Formatting based on Formula
    By Pete Petersen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2005, 08:06 PM

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