Results 1 to 7 of 7

conditional formatting an overriden formula cell

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2021
    Location
    houston, tx
    MS-Off Ver
    MS365 (release 2008)
    Posts
    3

    conditional formatting an overriden formula cell

    i would like to create conditional formatting that highlights if a cell is overridden. i am aware of the isformula idea which is great if someone hardcodes a formula cell, but i would also like it to identify if someone adds a suffix to a formula ["=sum(b6:d6)+5"] where the "+5" was tacked on to "override" the formula. in this case the isformula idea fails. any ideas on how to circumvent this?
    in the attached example, a6 should be highlighted in addition to a8.
    The formula will change with the row reference (now shown in this example) so the formula isnt static in the sense of the row reference but the formula is always the same outside of this (always summing B to D but just on different rows).
    i have tried the solution proposed beginning on row 12 but i am not sure how to set it so it considers the formula on row 13 for all subsequent rows (i doubt i have the formula correct).
    Attached Files Attached Files
    Last edited by lliberm1; 07-26-2021 at 03:16 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. conditional formatting with formula in cell
    By cricked in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2020, 11:21 AM
  2. [SOLVED] Conditional formatting on cell with formula
    By heytherejem in forum Excel General
    Replies: 6
    Last Post: 06-01-2018, 09:21 AM
  3. Replies: 3
    Last Post: 06-19-2015, 07:16 AM
  4. [SOLVED] Conditional Formatting of a cell that already has a formula in it
    By RJL3313 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-14-2015, 02:48 PM
  5. Conditional Formatting if cell contains formula
    By brokenbiscuits in forum Excel General
    Replies: 3
    Last Post: 07-26-2014, 01:45 AM
  6. [SOLVED] Conditional formatting a cell containing a formula
    By Nigel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2014, 05:58 AM
  7. Replies: 2
    Last Post: 08-27-2013, 03:38 AM

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