Excel query
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
19 April 2012
Hello All Experts
I have a query & hope i will find a right answer to that. I want to create a message box in excel 2007 where i can fix fix a cell with particular amount.
Means, if the amount in that particular cell increase by particular limit then a message displays automatically for the warning that the amount is increasing beyond limit.
e.g Cell A1 fix with rs. 5000/- . When A1 icrease to 5001/- then the message automaticaly displays " Amoount is beyond limit".
Can anybody help me out in this.
I have a query & hope i will find a right answer to that. I want to create a message box in excel 2007 where i can fix fix a cell with particular amount.
Means, if the amount in that particular cell increase by particular limit then a message displays automatically for the warning that the amount is increasing beyond limit.
e.g Cell A1 fix with rs. 5000/- . When A1 icrease to 5001/- then the message automaticaly displays " Amoount is beyond limit".
Can anybody help me out in this.
Mihir Doshi
(Expert)
19 April 2012
You can use conditional formating tools whereby you can define different rules. Suppose if you want certain cells to be in yellow colour if amount exceeds 5000 then you can do it.
Conditional Formating - press f1 and type conditional formating - you would get how to use the same.
Thanks
Mihir Doshi
Conditional Formating - press f1 and type conditional formating - you would get how to use the same.
Thanks
Mihir Doshi
Mihir Doshi
(Expert)
19 April 2012
You can use conditional formating tools whereby you can define different rules. Suppose if you want certain cells to be in yellow colour if amount exceeds 5000 then you can do it.
Conditional Formating - press f1 and type conditional formating - you would get how to use the same.
Thanks
Mihir Doshi
Conditional Formating - press f1 and type conditional formating - you would get how to use the same.
Thanks
Mihir Doshi
CA Kishore Tallam
(Expert)
19 April 2012
Yes. One way is conditional formatting. Another way is put a formula next to that cell like =if(cell reference>5000,"Beyond Limit,0)
Then whenever u put an amount, a message will be displayed.
Then whenever u put an amount, a message will be displayed.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Gst credit note by supplier
- GST on reimbursement of expenses
- Query on effect of registration of property
- Missed uploading GST Invoice
- Due date for filing return for the partner in partnership subjected to Tax Audit
- Wrong CMPo8 file
- Equity Share Sale and Purchase
- Visiting card purchase
- Number of years as per AS amortisation of Goodwill
- Whether output tax is taken credit by purchaser
- Classification of income of P Ltd company as business or profession
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
- RCM ON SECURITY CHARGES FROM INDIVIDUALS
- How to get money back from delisted company
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
