Hi,

Please could someone tell me if its possible and how to make a selection in a combo box change the background colour of a block of cells. The form I am creating will have a combo box with the options "approved" and "not approved". When approved i would like a block of cells to turn green, and when not approved for them to turn red. If anyone could help me on this that would be great, thanks.