Forum Discussion
Excel Formula
Do you mean something like this?
If so you may apply conditional formatting rule to the range with formula as
=(COUNTIF($A1:A1,A1)>=3)*(A1<>"")
apple banana apple banana apple banana orange orange orange
for the third banana, apple and orange it will automatically highlight the cell. meaning, instead of one exact value it is multiple values in one column. i dont know if my explanation is clear enough but i hope you understand
Do you mean something like this?
If so you may apply conditional formatting rule to the range with formula as
=(COUNTIF($A1:A1,A1)>=3)*(A1<>"")- yes thank you so much this is what i meant, but is it okay if you could post a tutorial or something because im kinda beginner with this stuff and my situation is affection columns if that will change anything. thank you once again!
To apply conditional formatting select you range, Home->Conditional Formatting->New rule and select this type of rule
Here add formula and desired format. Conditional Formatting iterates cells in your range one by one and triggers the format if the formula for the cell returns TRUE. That's important to start formula from the first (top left) cell of the range. For the each of next cells formula will be applied as you drag it on this cell, depend on how to use absolute and relative references. You may imitate such behavior applying formula to cells in other range:
COUNTIF() calculates how many times the value of the current cell appeared from the beginning of row. With next multiplier we ignore blank cells.
If apply Conditional Formatting to another range
the formula for conditional formatting rule will be
=(COUNTIF(M$2:M2,M2)>=3)*(M2<>"")Here we take cell M2 as starting one and shift relative reference from rows on columns.