Hi there guys,

I'm relatively new to this but would appreciate your help.

Basically what I am trying to do in excell to create visual alerts in
the same cell that I am inserting values.

For example in the cell I am entering data (for example a weight in
kg) for all entered data in the range of 0 - 200kg I would like the
background in the same cell to show as green (highlighting within
weight limits).

For all data entered between 200kg - 250kg I would like the background
to show yellow (diplaying slightly overweight) and for entered data
between 250kg - 300kg I would like the background of the cell to show
red (to highlight being grossly overweight).

Are you guys able to assist me with a formula/method to help
facilitate this?