| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make an alert system by Excel ?
on the second thought... the conditional formating is not working if i do this : cell value equal to =max(A1:A20)25 what should i do.. i have to do the comparison to know that the value already over limit... *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make an alert system by Excel ?
Select A1:A20
Do format=Conditional Formatting Change "Cell is" to "Formula is" Enter this formula =And(A1=MAX($A$1:$A$20),A125) Set your pattern. Regards, Tom Ogilvy Erche DP wrote in message ... on the second thought... the conditional formating is not working if i do this : cell value equal to =max(A1:A20)25 what should i do.. i have to do the comparison to know that the value already over limit... *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I open an Excel file on XP system, saved on a Vista system | Excel Discussion (Misc queries) | |||
| Is it possible to have an alert in Excel? | Excel Discussion (Misc queries) | |||
| excel causing system to be in low system resource | Excel Discussion (Misc queries) | |||
| How to make an alert system by Excel ? | Excel Programming | |||
| How to make an alert system by Excel ? | Excel Programming | |||
Linear Mode
