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.
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
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
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
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- GST on export of services and Input Credit
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- Applicable TDS rate for sale of property in Nov 2024
- Inventory of finished goods
- Tds on building rent monthly
- RCM INVOICING FROM NOV-2024
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Sale of property furniture sale
- Confusion around Form 26QB fields
- Adjustment entry in the case of Individual and HUF on 31st March
- Stock difference tax applicable on composite rate or normal rate
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
Trending Online Classes
CAclubindia
