how to highlight numbers that appear on a list

Hi experts,

I have this table below with the numbers and frequency

Number Frequency
1 1
12 1
13 1
49 2
17 1
2 2
20 2
21 1
23 2
40 1
25 1
27 1
28 2
3 2
32 3
33 1
34 1
35 1
36 2
5 1
45 1
9 3

I want to highlight the above numbers in this row list below such that higher frequency would have a darker shade of highlight. Pls refer to the attached excel book. Thanks.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

Originally Posted by TMS

Select the numbers from 1 to 50, and use the Conditional Formatting formula

Formula:

Please Login or Register  to view this content.

Hi TMS,

Your solution works but can the different shades depending on the frequency for eg. shade of frequency 3 is darker than shade of frequency 2 and shade of frequency 2 is darker than shade of frequency 1 able to work? Thanks.

Originally Posted by tanasedn

Hi,
select the range of cells you want to format and
insert 3 CF rules, one for each frequency, and choose a color you want for each.
For frequency 1

Formula:

Please Login or Register  to view this content.

And change the formula as you need.
See attached

Hi tanasedn,

Thanks, it works.

Originally Posted by tanasedn

Hi,
select the range of cells you want to format and
insert 3 CF rules, one for each frequency, and choose a color you want for each.
For frequency 1

Formula:

Please Login or Register  to view this content.

And change the formula as you need.
See attached

Hi tanasedn,

Is there any way that can count the number of highlighted cells? Thanks.