I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 45 towards the top of my home page.

What you need is Conditional Formatting and I have applied this to the range
K 1 to K 30 (inclusive) in my Workbook.

If you type in the values that you mention into this range you should find
that you get what you want.

You can also examine the Conditional Formatting rules by examining Home /
Conditional Formatting / Manage Rules.

Above is in EXCEL 2007.

Please hit Yes if my comments have helped.

Thank you.



"alchemist" wrote:

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?

.