Really struggle with Excel, so this might be a quick and easy one for someone out there?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
> </o
>
I want to conditional format a worksheet, which is to check for two criteria’s in two columns to capture duplications and then colour that row in the worksheet. <o
></o
>
<o
> </o
>
I can make this happen for the first check using countif to see if two numbers of the same value have been entered into column G =COUNTIF($G$2:$G$1009,$G2)>1. However, the second critera I just cannot get to work as one with 1<SUP>st</SUP>, as one countif statement.<o
></o
>
<o
></o
>
The second duplication check, is on column F which has an option of two text entries, which come from a data validation list. The two text options are FBR and TPT which has meaning to a vlookup I'm doing in column H based on the number entered in column G, returning the vlookup for the respective tabs of FBR and TPT.<o
></o
>
<o
></o
>
So I want to flag when number 1 in column G is already in the list and being used for vlookup for one tab, either FBR or TPT. Therefore I can have a number 1 as a vlookup for FBR tab & one for TPT tab, and this is not a duplicate. It's just when it the number has been entered twice for the same TAB, say FBR.<o
></o
>
<o
></o
>
Can someone help? <o
></o
>




<o


I want to conditional format a worksheet, which is to check for two criteria’s in two columns to capture duplications and then colour that row in the worksheet. <o


<o


I can make this happen for the first check using countif to see if two numbers of the same value have been entered into column G =COUNTIF($G$2:$G$1009,$G2)>1. However, the second critera I just cannot get to work as one with 1<SUP>st</SUP>, as one countif statement.<o


<o


The second duplication check, is on column F which has an option of two text entries, which come from a data validation list. The two text options are FBR and TPT which has meaning to a vlookup I'm doing in column H based on the number entered in column G, returning the vlookup for the respective tabs of FBR and TPT.<o


<o


So I want to flag when number 1 in column G is already in the list and being used for vlookup for one tab, either FBR or TPT. Therefore I can have a number 1 as a vlookup for FBR tab & one for TPT tab, and this is not a duplicate. It's just when it the number has been entered twice for the same TAB, say FBR.<o


<o


Can someone help? <o

