Solved

How do I carry conditional formatting through an entire section in EXCEL based on comparing values every two lines

Posted on 2016-11-30
4
12 Views
Last Modified: 2016-11-30
Experts,

I have an EXCEL file that is comparing data from two files.  Each file has multiple columns K2 though QC5000.  example row2 has File A info.  Row 3 has File B info  Row 4 has File A and Row 5 has File B  etc.

I want to highlight any column where FILE A is not equal to FILE B  is there a way to do this in EXCEL 10 using conditional formatting?
0
Comment
Question by:morinia
  • 2
4 Comments
 
LVL 14

Expert Comment

by:Juan Ocasio
Comment Utility
Do you have an example of the spreadsheet?
0
 

Author Comment

by:morinia
Comment Utility
Attached is sample
Diffs.xlsx
0
 
LVL 20

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
Comment Utility
Use this as conditional formula, in the range B2:BU9
=OR(AND($A2=$A3,B2<>B3),AND($A2=$A1,B2<>B1))
See sheet
-Diffs-Conditional-Formula.xlsx
0
 

Author Closing Comment

by:morinia
Comment Utility
Perfect, Thanks
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now