Trying to make this an auto function, currently doing it manually. I
receive a daily list of "customers" that in one column has a number that
codes each customer by what was done for them. These codes look like
"123.45, 123.78, 789.123, 999.001 etc". There are maybe 100 codes total and
15 codes that I want to fall into a group. What has to happen is to "flag"
(specific color) these codes out into 3 different groups. These groups may
be any code that starts with "123","789"or "999" etc. The numbers to the
right of the decimal point does not control what group they go into, only
the 3 numbers to the left of the decimal point. Lets assume the the 123
group will be the red group, 789 group is green group, 999 group is blue etc

i.e. to further to clarify, (confuse) :-)

Any number that begins with xx will be in the red group
xx = 123, 222, 541,346,718 up to 15 numbers here

Any number that begins with yy will be in the green group
yy = 789, 790, 791, 212, up to 15 numbers here

123.456, 123.001, 123.766, 222.100 etc gets filled in as red
789.123, 789.444, 789.345, 790.444 etc gets filled in as green

456.111, 333.567 etc does not get any formatting.

same for the 3rd group (blue)

"IF" conditions are way out of control, tried looking at a look up table
and somehow using that but getting bogged down. I made a table populated
with the numbers for the "RED" group, same for green and blue.

Original data comes in 15 column format, the "Code" will be in column "D"
and that cell is the one that will get the conditional format, rows vary,
maybe 10-50 total a day. I could get away with inserting a "FLAG" column
next to the code if necessary.

Tx for any guidance.