need help with color code to map the age and input the first name and last name in Excel

[sammas]

need to populate the names into columns M to R based on the color codes from Column E.

 

[sammas]

Need help on this - need to populate the names into columns M to R based on the color codes from Column E.

 

[vletm]

sammas​

You've tried to code those with Conditional Formatting.
There seems to be some challenges.
Instead of that ... You could populate names with ages.
This is one sample - how to do it.

 

[p45cal]

Try, in cell M5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=5,"")
N5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=6,"")
O5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=7,"")
P5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=8,"")
Q5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=9,"")
R5:
=FILTER($C$5:$C$116 & " " & $B$5:$B$116,DATEDIF($D$5:$D$116,TODAY(),"y")=10,"")
etc.