Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flagging all records present in two (or more) separate lists
How can I get Excel 2007 to flag (using conditional formatting?) records that
are present in two or more separate lists? I thought this was straightforward enough but couldn't find the instruction in the forum nor in the help file. Perhaps my search key isn't good enough... -- Maki @ Canberra.AU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flagging all records present in two (or more) separate lists
Hi,
Highlight the first cell you want to conditionally format, choose Home, Conditional Formatting, Manage Rule, New Rule, Use a formula... Enter the formula =COUNTIF($F$10:$F$17,C9)0 where C9 in the first cell you want formatted, the range F10:F17 is the range you want to check for duplicated. Format as needed. Use the format painter to copy and paste the format from this cell to all the cells in this column. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Maki" wrote: How can I get Excel 2007 to flag (using conditional formatting?) records that are present in two or more separate lists? I thought this was straightforward enough but couldn't find the instruction in the forum nor in the help file. Perhaps my search key isn't good enough... -- Maki @ Canberra.AU |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flagging all records present in two (or more) separate lists
Yes, it helped! Thank you, Shane!
-- Maki @ Canberra.AU "ShaneDevenshire" wrote: Hi, Highlight the first cell you want to conditionally format, choose Home, Conditional Formatting, Manage Rule, New Rule, Use a formula... Enter the formula =COUNTIF($F$10:$F$17,C9)0 where C9 in the first cell you want formatted, the range F10:F17 is the range you want to check for duplicated. Format as needed. Use the format painter to copy and paste the format from this cell to all the cells in this column. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Maki" wrote: How can I get Excel 2007 to flag (using conditional formatting?) records that are present in two or more separate lists? I thought this was straightforward enough but couldn't find the instruction in the forum nor in the help file. Perhaps my search key isn't good enough... -- Maki @ Canberra.AU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare lists - count # records | Excel Worksheet Functions | |||
Merge two lists to get one with unique records | Excel Discussion (Misc queries) | |||
separate 2 different lists | Excel Discussion (Misc queries) | |||
Need help comparing & flagging email lists | Excel Discussion (Misc queries) | |||
Separate records from Vertical to Horizontal | Excel Worksheet Functions |