When creating DoEs, each column is usually a mixture of 2 or 3 different values (high and low values, and sometimes a center value). To better illustrate the DoE setup to myself and my coworkers, I manually color the cells in each column. The high values are colored red, the center values are colored green, and the low values are colored blue. It would be beneficial to automate this coloring process. I want to be able to run a script that will color the cells in the selected columns according to the description above. Ideally, the script should be able to do this process for multiple selected columns simultaneously. Any suggestions as to how such a script could look like?
