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! |
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! |
All times are GMT +1. The time now is 06:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com