Excell solution - conditional formating

This query is : Resolved 
Avatar

Querist : Anonymous

Profile Image
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
Profile Image

Nikhil Kaushik

Profile Image

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



Similar Resolved Queries


loading


Unanswered Queries


Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Pro Member GOVIND VAJIRAJ DESAIGOVIND VAJIRAJ DESAIPro Member Veerabadrayya TVeerabadrayya TPro Member Manjunath JManjunath JPro Member Leena RachhLeena RachhPro Member George InnocentGeorge Innocent
Subscribe to Pro
Join an elite circle of professionals



Answer Query



Quick Links



Browse by Category