Rows of data from two sources have been combined and sorted on one worksheet.
To identify the source of the data, the rows are 'flagged' with the acromyns
"ign" or "leg". The only reason they are appearing on this report is that
there is/are cell(s) of data that have been incorrectly entered in one of the
two records.
In this worksheet, I need to find and highlight the following:
1) If the data in Column A1 equals ign and Column A2 equals leg and
2) If columns B1 and B2 records numbers are the same then
3) Find the cell(s) within range C1 thru AE1 and C2 thru AE2 that are
different and highlight them.
This will be comparing two rows of cells, C1 thru AE1 and C2 thru AE2.
Earlier, I was given these formula to enter as a conditional formatting
formula:
=IF($A1=$A2,A1<A2,FALSE)
=IF($A65536=AB1,A65536<A1,FALSE)
The above formula highlights some cells, but it seems random; and, it does
not do #3. It does not search the rows of cells, C1 thru AE1 and C2 thru
AE2, for different values; this would be the information to highlight.
So, can you help me with this formula?
phmckeever