hello all,

I am wanting all cells in range:G18-AC53 with the number 1 to be red,with number 2 to be pink, number 3 to be green, number 4 to be yellow and number 5 to be black. Only in one sheet called test of a workbook with 5 sheets. Is this possible?

Is