Conditional Formatting for Duplicates

Hello,

I'm trying to come up with conditional formatting for the attached sheet.

I want it to highlight all cells that contain duplicate numbers as in the number is present in all five days, no less, and is highlighted with a color.

Then, likely another formula, that will highlight all the numbers that are present (duplicates) in any four of the days, no more no less.

The same with three days, and two.

I've been trying to get Countif to work but it is not.

Thank you.

Thanks protonLeah,

However I am still getting the same sort of results I have been...

112 for example exists in all five days.

Changing the 2 in the formula starting from 1 to 5 one at a time, the only time 112 is highlighted at all is when set to 3 and then only three out of the five occurrences of 112 are highlighted.

When it is set to 1 two of the five occurrences are highlighted.

Set to any other number none of 112 is highlighted.

Maybe I am misunderstanding something.

No but thank you. That gets all the duplicates alright.

The numbers in the sheet refer to a city-wide radio control and monitor system. Am trying to improve communications to the remotes so am identifying the worst to least ones. That is why they need to be color coded differently.

The worst ones do not communicate on any day (colored red). The next to worst ones do not communicate 4 out of 5 days (colored yellow) and so on.

Using 112 as the acid test in this case which exists in all five days and using 5 as the formula value, none of the 112's are highlighted. Highlighting seems almost random.

I have it downloaded it twice now. Something goes odd with the browser and it doesn't redirect or click to redirect.

I was able to download the workbook, it shows cells separated into differing colors just as requested, however even after closing and reopening this thread the count still reads zero views.

Hmm. Ok I will have to check on this. It kept asking me to download it and I did a few times. It asks to download but doesn't redirect. I have recently upgraded the browser I might need to try another one.

Thanks for your time!

Thank you. Something was going wrong when downloading. I finally got it.

That is beautiful. Very elegant.