Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionally formatting rows | Excel Worksheet Functions | |||
Conditionally formatting highest valued cell? | Excel Worksheet Functions | |||
Conditionally formatting other cells? | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) |