Conditional Formatting - Compare two rows respectively
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.
Can someone please help me out.
Cheers
G_M
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.
Can someone please help me out.
Cheers
G_M
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER