ElaKiri Community
Downloads
Go Back   ElaKiri Community > General > ElaKiri Help
Reload this Page Excel උදව්වක් ඕන (VBA හරි කමක්නෑ)
Reply
 
Thread Tools
(#21)
Old
TakaTakas's Avatar
TakaTakas TakaTakas is offline
Senior Member
TakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of light
 
Posts: 3,072
Join Date: Nov 2014
Location: ගෙදර
07-23-2019, 03:35 PM

උදව් කරපු හැමෝටම ස්තූතියි.මෙන්න මේක තමයි මට ඇත්තටම කරගන්න ඕන.



Link
Reply With Quote
(#22)
Old
Kasun93 rox's Avatar
Kasun93 rox Kasun93 rox is offline
Senior Member
Kasun93 rox has a spectacular aura aboutKasun93 rox has a spectacular aura aboutKasun93 rox has a spectacular aura aboutKasun93 rox has a spectacular aura aboutKasun93 rox has a spectacular aura about
 
Posts: 735
Join Date: Jun 2012
07-23-2019, 11:35 PM

Ara kali kiyala tibba conditional formatting walin karanna puluwanne bn oka.

Oya button eke case eka nm ba ithn ehema
Reply With Quote
(#23)
Old
TakaTakas's Avatar
TakaTakas TakaTakas is offline
Senior Member
TakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of light
 
Posts: 3,072
Join Date: Nov 2014
Location: ගෙදර
07-24-2019, 12:53 PM

Quote:
Originally Posted by AcAciA View Post
machan ube spread sheet eka dapan mata hadala dennam online upload karala link danna
Quote:
Originally Posted by wqe123 View Post
"හැබැයි A3 = B8 , එහෙම උනාට ඒ සෙල් පාට වෙලා නෑ."

උබට ඕනේ duplicate වෙච්ච value එකක් මාර්ක් කරන්න වගේ තාමා මට තේරුනේ
එක හරි නම්



excel2013 - conditional format වල "format only unique or duplicate value" දාල "duplicate" ටික මාර්ක් කරගන්න එක කරන්න පුලුවන්
Quote:
Originally Posted by Kolama View Post
Bumpation
Quote:
Originally Posted by amarakak View Post
Can do using conditional formatting. send me the spreadsheet I will do
Quote:
Originally Posted by wasantha99 View Post
bump
Quote:
Originally Posted by Ek buwa View Post
select the two columns first.
and then in HOME tab click on "Conditional Formatting"
then click on "New Rule"
then select "Use a formula to determine which cells to format"
add this formula "=$B1=$A1" in the text box below.
then click on FORMAT button. click FILL tab.
select a color you want to highlight the duplicate values.
Click OK and again OK.

hope this will work.
Quote:
Originally Posted by ArunaTelshan View Post
Quote:
Originally Posted by imhotep View Post
This is easily done by a conditional formatting rule.
Select your two columns by first selecting the firs row.
Then Conditional Formatting --> New Rule ---> Use a formula to determine which cells to format
Type in the rule description =$A1=$B1
Press Format button - select colour
Press OK - it's done.
Quote:
Originally Posted by ryandok View Post
bump
Quote:
Originally Posted by imhotep View Post
Sorry.. I replied while looking only at Page No#1 - only later saw that the member Ek buwa has already posted exactly the same.
Quote:
Originally Posted by hirugalbandara View Post
Quote:
Originally Posted by Kasun93 rox View Post
Ara kali kiyala tibba conditional formatting walin karanna puluwanne bn oka.

Oya button eke case eka nm ba ithn ehema
සේරටම ස්තූතියි.
කන්ඩිෂනල් ෆෝමැටින් වලින් කරන්න පුළුවන් ඒත් මම උඩින් කියල තියන විදියට කරගන්න තිබුනනම් තමයි හොද.තාම බැරිඋනා මචං වැඩේ කරගන්න.පුළුවන් එකෙක් ඉන්නවනම් ඔය දාල තියන ලින්ක් එකෙන් ගිහින් මගෙ ෆයිල් එක බාගෙන ඒකෙ කෝඩ්එක සෙට් කරල දෙනවද?
https://drive.google.com/open?id=1x8...3_ZCYYw1NnTA-O

Reply With Quote
(#24)
Old
amarakak amarakak is offline
Member
amarakak is on a distinguished road
 
Posts: 88
Join Date: Feb 2010
07-24-2019, 01:22 PM

Where can I upload the solved one
Reply With Quote
(#25)
Old
TakaTakas's Avatar
TakaTakas TakaTakas is offline
Senior Member
TakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of light
 
Posts: 3,072
Join Date: Nov 2014
Location: ගෙදර
07-24-2019, 01:34 PM

Quote:
Originally Posted by amarakak View Post
Where can I upload the solved one
Email address MPed machan.
Reply With Quote
(#26)
Old
asknrk's Avatar
asknrk asknrk is offline
Senior Member
asknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of light
 
Posts: 2,813
Join Date: Feb 2007
Location: @Thusithaya
laugh 07-24-2019, 01:37 PM

send email
Reply With Quote
(#27)
Old
TakaTakas's Avatar
TakaTakas TakaTakas is offline
Senior Member
TakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of light
 
Posts: 3,072
Join Date: Nov 2014
Location: ගෙදර
07-24-2019, 01:57 PM



මෙහෙම එන්නෙ ඇයි මචං. මට දැන් කවුරු හරි මේල් එකක් එවල තිබුනා Excel ෆයිල් එක හදල ගන්න බයයි
Reply With Quote
(#28)
Old
imhotep imhotep is offline
Senior Member
imhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to allimhotep is a name known to all
 
Posts: 3,538
Join Date: Mar 2017
07-24-2019, 02:02 PM

If you want to press a button to do this then you have to enable the Developer mode, insert a Button Form control and assign a VBA macro code to do the job.
Reply With Quote
(#29)
Old
TakaTakas's Avatar
TakaTakas TakaTakas is offline
Senior Member
TakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of lightTakaTakas is a glorious beacon of light
 
Posts: 3,072
Join Date: Nov 2014
Location: ගෙදර
07-24-2019, 02:14 PM

Quote:
Originally Posted by imhotep View Post
If you want to press a button to do this then you have to enable the Developer mode, insert a Button Form control and assign a VBA macro code to do the job.
Thanks Lot Machan.
Reply With Quote
(#30)
Old
amarakak amarakak is offline
Member
amarakak is on a distinguished road
 
Posts: 88
Join Date: Feb 2010
07-24-2019, 03:59 PM

check your emails I have sent again
Reply With Quote
Reply

Bookmarks

Tags
mydone

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



Copyright © 2006 - 2011 ElaKiri™ Beta2.Evo vBulletin, vBa iBproArcade Subdreamer I-Magic MKv

Page generated in 0.04296 seconds with 9 queries