Hi, i have a spreadsheet with a number of named ranges called

section1red, section1amber and section1green
section2red, section2amber and section2green
section3red, section3amber and section3green

Cells in each range may or not be populated with integers (always positive).

Is there a way using VBA to automatically turn the range:
section1red to red background
section1amber to amber background
section1green to green background

when the cell is populated with a value and ignore otherwise (ie: remain white) ?

Hope that is achieveable, thanks for your help.
Luce x