Conditional Formatting

[mjbrant0]

• I'm trying to create an inventory maintenance log where column K will display the number of occurrences of any given serial number in column D.
• I'd also like the cells to be green when there's 1 occurrence, yellow when there are 2-3 occurrences and red when there are 4+ occurrences. I've been playing around with this for 45 minutes and I'm lost.

Any help is appreciated.

 

[Joe4]

Welcome to the Board!

You can use the COUNTIF formula to return the number of occurrences, i.e.
If you have entries in rows 2:100, then place this formula in K2:

=COUNTIF($D$2:$D$100,$D2)

If you want it so the first occurrence of a value is 1, the second is 2, etc, then use this variation:

=COUNTIF($D$2:$D2,$D2)

Then it should be pretty easy to apply Conditional Formatting to the numbers in column K.