Excell solution - conditional formating
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
15 February 2014
Dear All,
I hv a excell sheet, there are three colomn A, B & C. A contains name of contries, b contains name of ministers all time and c contains sub ordinate officers as like follows :
A B C
India Manmohan rahul
atal bihari modi
lalu yadav mamta
US a x
b y
c z
There is big data and I need to create a diffrent worksheet for each contry means w.s. 1 india, w.s. 2 us etc by using conditional formatting.
Kindly help me in detail. Plz....
Thanks in advance.
Ram
I hv a excell sheet, there are three colomn A, B & C. A contains name of contries, b contains name of ministers all time and c contains sub ordinate officers as like follows :
A B C
India Manmohan rahul
atal bihari modi
lalu yadav mamta
US a x
b y
c z
There is big data and I need to create a diffrent worksheet for each contry means w.s. 1 india, w.s. 2 us etc by using conditional formatting.
Kindly help me in detail. Plz....
Thanks in advance.
Ram
Nikhil Kaushik
(Expert)
15 February 2014
conditional formatting doesnt help you in such case..you need to use macros.
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
- EPF ECR NEW FILE SEP 17TH 2026
- TDS Challan - change of FY 2025-26 to TY 2026-27
- Gst registered proprietorship firm
- AUDITOR APPOINTMENT FOR THE YEAR ENDING MARCH 27
- Capitalgain tax purposes for valuation report compulsory
- TDS on Fixed Assets purchased
- GST Intimation due to Government took possession of Business Premises under PPE Act
- TDS on purchase of under construction property from a reseller
- Non filing of I T Returns
- SALARY CAN BE CAPITALIZE
- TAX AUDIT ON PROFESSIONAL INCOME
- Under marginal scheme
- Import of Software Service.
- Clarification Requested: Gift → NRO → NRE → Overseas Transfer - USA/CANDA (FEMA & Tax Compliance)
- GST on Renting godown to KFCSC for Storage of Raagi
- How to Handle Active E-Invoices in GST Portal Deleted from Tally?
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
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
