[Rob T Parry]

I would like to change the background colour of a field in a table depending on the content of the field.

If I enter an R in the field I would like the background to go Red.

If I enter an A in the field I would like the background to go Amber.

If I enter an G in the field I would like the background to go Green.

Hope some can help as its driving me nuts.

Its so easy in Excel!!!