Conditional Formatting


G

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.
 
Ad

Advertisements

G

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)
 
G

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
 
Ad

Advertisements

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top