conditional formatting help

[chillyrose]

Hi guys

Would someone be able to help me with the correct formula to enable me to do the following. I assume I need to use conditional formatting(?) -
I want a row to turn red if the name in cell c of that row appears 8 times previously in column c.

This is probably quite straight forward but I'm a novice.

thanks for you help

 

[onlyadrafter]

Hello,

select row 9, select FORMAT --> CONDITIONAL FORMATTING, change cell value is to FORMULA IS and enter

=COUNTIF($C$1:$C8,$C9)=8

and format as required.

USe the format painter to format all other rows below.

This will colour all rows below in red. Is that what you want?

 

[chillyrose]

Perfect - thank you

 

[Miloni]

try the following: in the column C enter the following in Format --> Conditional Formatting. In condition 1 chose Formula is and enter =countif(c: c, c10)>8 and click format and choose the patterns tab and choose the red color to color the cell. This would only color the cell and not the row..

But you have to enter the above formula in all the cells of column C till you want.
Let me know if it worked or not.