awk

BEGIN           { FS = ","; col = "COLOR1"; i = 1 }
!/^[0-9]/       { next }

$3 == ""        {
                    val = sprintf("%.0f", $2)
                    data = data ? data OFS val : val
                    col = col OFS "COLOR" ++i
                    next
                }

$2 < min        { min = $2 }
$3 > max        { max = $3 }

END {
        printf("NAME:nFROM= %s %snTO= %s %snCOLOR= %sn",
               min, data, data, max, col)
    }

$ awk -f script.awk file.csv
NAME:
FROM= -100 -346 -249 -125
TO= -346 -249 -125 100
COLOR= COLOR1 COLOR2 COLOR3 COLOR4

awk 'NR>1 && NR<5{
         v=sprintf("%.0f", $2); values=(values)? values FS v : v;
         lbl="COLOR"; col_item=lbl""++c; col=(col)? col OFS col_item : col_item
     }
     NR==6{ from=$2 }
     END{
         print "NAME :"; print "FROM=",from,values;
         print "TO=",values,$3; print "COLOR=",col,lbl""++c
     }' file

NAME :
FROM= -100 -346 -249 -125
TO= -346 -249 -125 100
COLOR= COLOR1 COLOR2 COLOR3 COLOR4