Conditional format help
"T. Valko" wrote:
The numbers are all different but there comes a
point when they start to repeat
Try this...
With your data in the range A2:B9...
Selet the *entire* range A2:A9 starting from cell A2. Cell A2 will be the
active cell. The active cell is the one cell in the selected range that is
not shaded. The formula will be relative to the active cell.
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND(COUNTIF(B$2:B$9,B2)1,COUNTIF(B$2:B2,B2)=1)
Click the Format button
Select the desired style(s)
OK out
--
Biff
Microsoft Excel MVP
Okay this formula works but it highlights the first value that's part of the
repetition. So just in case I have a 5 in B2 but then the repetition of 5's
starts in B10 it will highlight B2 since there was a 5 there. Can you have
it only do the highlight when it's the beginning of the repetition part??
This could work but it's possible that I might have avalue earlier in the
column that matches the repetition value.
Ms-learner the formulas you posted didn't do what I need, thanks but they
all highlight different areas.
|