Hi Juuljus,

Does this sound right.....

Each cell from AN10 down to AN30 is to have a colored circle and its
color is determined by the text in the cell to its immediate left. So
if AM10 = "yellow" then the circle in AN10 has a yellow fill. If AM11 =
"red" then the circle in AN11 has a red fill and so on down to row 30?.

Ken Johnson