Solved

Conditional Formatting - Compare two rows respectively

Posted on 2011-02-15
3
338 Views
Last Modified: 2012-06-27
Hey guys,

I have been fiddling around with Excel for ages now and cannot do what seems to be a simple task.

I have two rows of data which I want to compare. If the information matches I want the cell in the 2nd row to turn green, if the information doesn't match I want the cell to turn red.

Thus for the data below, F1&F2 should be red and F3:F9 should be green.

  Data
Can someone please help me out.
Cheers
G_M
0
Comment
Question by:G_M
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
TommySzalapski earned 250 total points
ID: 34903582
Take out the $ and it should work.
When you set the formula, select the entire column F and set on the condition that it =E1 not =$E$1 and it should work.
0
 
LVL 37

Assisted Solution

by:TommySzalapski
TommySzalapski earned 250 total points
ID: 34903590
You also might want to add the condition that if they are equal F1 isn't blank. See the example sheet. I used
=F1<>E1 fill red
=AND(F1=E1,NOT(ISBLANK(F1))) fill green
format.xls
0
 

Author Comment

by:G_M
ID: 34903857
Thankyou
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

862 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

23 Experts available now in Live!

Get 1:1 Help Now