Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alerts....
hello,
i am trying to set up a budget sheet in excel. is there any way to set excel so that a cell will change colors or do some type of alert when it has hit a maximun number. for example: i have a column for expendatures and a cell at the bottom is formulated to add it all up. i want to know if there is someway to set a max amount of the sum, in that cell and excel alerting me when i exceed that max amount? --- frmsrcurl: http://msgroups.net/microsoft.public.excel.misc/2 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alerts....
Hi,
Have a look in Excel help for conditional formatting and if you get stuck post back. Mike "gustin" wrote: hello, i am trying to set up a budget sheet in excel. is there any way to set excel so that a cell will change colors or do some type of alert when it has hit a maximun number. for example: i have a column for expendatures and a cell at the bottom is formulated to add it all up. i want to know if there is someway to set a max amount of the sum, in that cell and excel alerting me when i exceed that max amount? --- frmsrcurl: http://msgroups.net/microsoft.public.excel.misc/2 . |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alerts....
it works, yes. another question arrose upon doing that though: how do I put a value between a minimum number and a maximum number? for example: 150 but <200. I want the alert to show up between those two numbers. this formatting doesn't seem to like doing that. how do I get around it?
--- frmsrcurl: http://msgroups.net/microsoft.public.excel.misc/Alerts |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alerts....
if i understand correctly, this may work for you. select formula in the dropdown and paste this formula, just change the cell reference. =AND(A1150,A1<200) -- Gary Keramidas Excel 2003 "gustin" / wrote in message ... it works, yes. another question arrose upon doing that though: how do I put a value between a minimum number and a maximum number? for example: 150 but <200. I want the alert to show up between those two numbers. this formatting doesn't seem to like doing that. how do I get around it? --- frmsrcurl: http://msgroups.net/microsoft.public.excel.misc/Alerts |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alerts....
that did the trick!!! thank you both!!!
--- frmsrcurl: http://msgroups.net/microsoft.public.excel.misc/Alerts |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alerts | Excel Discussion (Misc queries) | |||
Alerts | Excel Discussion (Misc queries) | |||
Email alerts | Excel Discussion (Misc queries) | |||
alerts | Excel Worksheet Functions | |||
Alerts? | New Users to Excel |