I need a script to check all cells from : "a2:a" & xrow and if the value in the cell is between 0 - 200 , then colour the cell green if between 201 - 300 amber , if between 301 - 400 then red , and if above 401 pink.
Can anyone assist with the writing of this code ?? xld where are u ??