+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting

  1. 05-10-2021, 10:06 AM #1
    jimpatel1993
    jimpatel1993 is offline
    Forum Contributor
    Join Date
    01-21-2021
    Location
    Leeds
    MS-Off Ver
    2016
    Posts
    236

    Conditional formatting

    Thanks for looking at my post.
    I am bit stuck with conditional formatting. I have 3 different column title. Title 1 till title 9 and secondly title 1a till title 9a and third title 1b till title 9b. I wanted to highlight in red if there is any change in the value in the row and in the respective title please. Example in row 4 changes happened in cell C4 for column titled 1 till title 9. In row 5, in column title1a till title 9a the changes happened in O5.

    Another example in row 10, change happened in H10 and so on. I have 100s of rows and any idea guys ?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-11-2021, 12:54 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Conditional formatting

    Not sure I understand how you are testing for the changes?

    is it within a title "type" eg within title, or within title A etc?
    or is it across titles eg title vs title A vs title B?
    in your 1st example....
    "row 4 changes happened in cell C4 for column titled 1 till title 9"
    why is it title 9 and not title 6?...or why title 2 (C4) and not title 4?

    Explain your logic to me please.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 another cells Conditional Formatting
    By chriskay in forum Excel General
    Replies: 4
    Last Post: 08-22-2019, 05:33 AM
  2. [SOLVED] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  3. Conditional Formatting Removing Previous Conditional Formatting?
    By CravingGod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 01:02 PM
  4. [SOLVED] Keep conditional formatting results, but remove the conditional formatting?
    By mattsonberg in forum Excel General
    Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  5. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  6. Conditional formatting based on conditional formatting of other cells?
    By justinr in forum Excel General
    Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  7. Conditional Referencing Cell Ranges to avoid Conditional Formatting Cells Indvidually?
    By mrvp in forum Excel General
    Replies: 3
    Last Post: 05-15-2012, 04:13 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1