Conditionally Formatting
 

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

Conditionally Formatting
 

Select C1 thru AE1

Then if CF use a formula of

=AND($A1="ign",$A2="leg",$B1=$B2,C1<A2)

and pick a format

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"phmckeever" wrote in message
...
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