Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need conditional formatting help!!!
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |