Results 1 to 5 of 5

Thread: Article: Understanding How Conditional Formatting Rules Are Applied

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider

    Article: Understanding How Conditional Formatting Rules Are Applied



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    I am trying to compare information contained on 2 seperate worksheets and if the information does not match I want the cell to turn red. I have read evertying I could find and tried several different "Fixes" but none of them work.

    Finer details
    Worksheet #1 containes a "Master Matrix"
    Worksheet #2 containes the most recent report query based on the same start date range to current date.

    A daily or weekly report is generated and exported to an excel file.
    The information from this report is copied and pasted into my file on worksheet #2 where worksheet #1 compares itself to worksheet #2 and anything that is different the cell is highlighted red.
    Both worksheets contain exactly the same amout of columns. The number of rows can and will change as new issues or concerns are generated from the report. Also the information contained within each cell of the report can change (ie, quantities, cost, BIN code, etc) so we want an easy way for these changes to be identified on worksheet #1 by changing the color which prompts us to look at that particular cell to see what was changed. No automatic updates required, just a flag to review the modified data.

    I hope that I have explained this ok.

  3. #3
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,359
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Nice work Ken.

    I would also like to add that all CF formulas are considered as array formulas. So, if you need an array formula to define your CF, don't bother about Ctrl+Shift+Enter

  4. #4

    Conditional Formatting

    i have a query on conditional formatting

    i am working on a data and i need to put conditional formatting for the same.. data is as under

    Detail 1 Detail 2 Comments
    500 650 Green
    400r 300 Red
    200 250 Green
    200 200 Yellow









    Now i want to put conditional formatting in this if detail 2 is grater than detail 1 color should be green, if smaller than it should be red. otherwise yellow.. yes we can do it with formula as u explained on the top.. but this i need to do for around 200 line items.. and i cant apply the formula on one cell and copy and paste .. awaiting for the response thanks in advnace

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Apologies, folks. I don't get notified of responses to these posts, so for anyone else looking for help on this article, please post in the forum at http://www.excelguru.ca/forums/forum.php. That way an expert will see it.

    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •