Creating Visual Excel Cell Alerts

A

alchemist

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?
 
T

trip_to_tokyo

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.
 
S

Simon Lloyd

You can't show a change in cell colour whilst in edit mode you can onl
show a change in colour after you have entered the data or exited th
cell and therefore exiting edit mode. But what you ask can be done wit
conditional formatting, what version of Excel are you using

alchemist;619042 said:
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 i
the same cell that I am inserting values

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

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

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

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com
 
W

WallyWallWhackr

My football stats sheet turns green as the wins column grows larger,
and turns red as the losses column grows.

I have a Blood Pressure Tracker where the conditional formatting
changes the cell background color if the heart rate entered is above a
certain value. I also have it so that value can be selected.

So you can even set up a sheet where you can adjust those "alarm
points".

My sheets are posted on the Microsoft Office user submitted templates
page.

http://office.microsoft.com/en-us/templates/profile.aspx?id=ecf5ad5a-9584-4787-bb16-70f61ad52e0f

I do not know how much examples help, because you actually have to
familiarize yourself with the conditional formatting tools and menu
actions/choices, etc. anyway, but those sheets have some conditional
formatting examples that you might be able to use. HTH
 
C

CellShocked

You can do it if you use a cell to reference to another cell, and use a
drop down list. It updates immediately upon selection, and does not exit
the cell. It works in a drop down listed cell alone as well.

Here it is. There is no password, just hit enter.

http://www.mediafire.com/?mzlo4tzom4m
 
C

CellShocked

On Thu, 21 Jan 2010 20:01:41 -0800, CellShocked



Snip...

Did you go check out the workbook I posted? (we'll never see him
again).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top