Article: Understanding How Conditional Formatting Rules Are Applied

[Ken Puls]

You can view the page at http://www.excelguru.ca/content.php?...es-Are-Applied

[R Cubed]

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.

[Pecoflyer]

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

[canischintsomani]

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

[Ken Puls]

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!