Conditional Formatting

[Guest]

I am trying to Build a relationship between two different columns. The data
comes from two different spreadsheets(SS). I copy and paste them into a
third sheet then compare like data. The data from SS1 is in columns A, B, C,
D and the data from SS2 is in columns E thru H. How can I format the Countif
function to reference data location A1 and E1? I have tried
Countif(A1:E1,A1) but that compares all columns A thru E and says true if any
of those fields match. I have done the work around and put like data next to
each other but if I did not need to do that that would be easier. Any help
would be appreciated.

 

[Guest]

am not really sure what you want.
Do you want to know if A1 and E1 are identical?
Try =A1=E1 for a true or false answer
Do you want to know if A1 is duplicated somewhere in E1:H??.
(more complicated)

 

[Guest]

What I am trying to do is in Column A compare the data to column E while
remaining in the same row, then using conditional formatting highlight the
rows in column A that match column E

 

[Guest]

Disregard I figured it out. Rather than use a formula for conditional
formatting I used the cell is option. Thanks for the input