Solved

Conditional Formatting - Compare two rows respectively

Posted on 2011-02-15
3
337 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

706 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

20 Experts available now in Live!

Get 1:1 Help Now