Need conditional formatting help!!!

Someone help me about the excel problem? Really need your help!! Thank you!!

My logic: colour the duplicate values in column F, except that the corresponding value in G column = 330.

So I wrote the following formulas in conditional formatting and get the result as follows.

Rule1: formula: =G2=330, applies to $F$2:$F$11
Rule2: duplicate values, applies to $F$2:$F$11

F G
2 240 330
3 960 1320
4 4800 6600
5 32160 44220
6 240 300
7 10 20
8 10 20

But what I want the result is as follows. Since G2=330, so 240 (F2) will be coloured blank, then F6 should be coloured blank since the value in F2 (240) = Value in F2 (240).
F G
2 240 330
3 960 1320
4 4800 6600
5 32160 44220
6 240 300
7 10 20
8 10 20

Hi Nancy,

Am Thu, 12 Jul 2012 01:58:15 +0000 schrieb NancyX:

> But what I want the result is as follows. Since G2=330, so 240 (F2) will
> be coloured blank, then F6 should be coloured blank since the value in
> F2 (240) = Value in F2 (240).
> F G
> 2 240 330
> 3 960 1320
> 4 4800 6600
> 5 32160 44220
> 6 240 300
> 7 10 20
> 8 10 20

select F2:F8 and paste following formula to the CF:
=(COUNTIF($F$2:F2,F2)>1)*(G2<>330)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2