$$Excel-Macros$$ Re: problem highlighting duplicated cells based on a condition

2009-02-27 Thread Jeff Hall
Format-> Conditional Formatting is your friend The easiest thing to do is to select the first box (B2 if I'm reading your cheat sheet right) and do the following Format-> Conditional Formatting Choose Cell Value Is from the first drop down Choose Equal To from the second drop down Type "=B$1" in

$$Excel-Macros$$ Re: problem highlighting duplicated cells based on a condition

2009-02-27 Thread Peter Jorgensen
This could be done by a VBA function but I'm curious how this will be checked. You have the data, is it being continuously changed? Do we need to check it continually? Do we need to compare all values of familyX and familyY or just two specific rows at a time? Are familyX and familyY constantly be