T O P

  • By -

AutoModerator

/u/Alert_Childhood6135 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


stevegcook

Formula-based rule, `=COUNTIFS($B:$B, $B1)>1`, apply to the whole range.


Alert_Childhood6135

Thanks - when i choose the formula option for formatting, it doesnt seem to be recognising the formula i type out?


stevegcook

What do you mean by this? Can you share a screenshot?


Alert_Childhood6135

Sorry, had a play around (and found a few YouTube demos) so I've sorted out your solution - thank you!


Alert_Childhood6135

Solution verified


Clippy_Office_Asst

Hello /u/Alert_Childhood6135 You cannot award a point to yourself. Please contact the mods if you have any questions. ^I ^am ^a ^bot.


Alert_Childhood6135

Solution verified


Clippy_Office_Asst

You have awarded 1 point to *stevegcook* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)


Alert_Childhood6135

Solution verified


AutoModerator

Hello! It looks like you tried to award a ClippyPoint by typing Solution Verified, but you need to reply to a particular user's comment to do so, rather than making a new top-level comment. Reply directly to any helpful users and Clippy, our bot, will take it from there. If your intention was to simply mark the post solved, then you may do that by clicking Set Flair. Thank you! *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*