ElaKiri Community
Downloads
Go Back   ElaKiri Community > General > ElaKiri Help
Reload this Page Excel උදව්වක් ඕන (VBA හරි කමක්නෑ)
Reply
 
Thread Tools
(#11)
Old
madhustf's Avatar
madhustf madhustf is offline
Senior Member
madhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to all
 
Posts: 5,620
Join Date: May 2008
Location: Kurunegala
07-23-2019, 10:09 AM

Bump
Reply With Quote
(#12)
Old
Kolama's Avatar
Kolama Kolama is offline
Senior Member
Kolama has much to be proud ofKolama has much to be proud ofKolama has much to be proud ofKolama has much to be proud ofKolama has much to be proud ofKolama has much to be proud ofKolama has much to be proud ofKolama has much to be proud ofKolama has much to be proud ofKolama has much to be proud ofKolama has much to be proud of
 
Posts: 8,678
Join Date: Sep 2008
Location: ලිම්පෝපෝ කන්දෙ
07-23-2019, 10:39 AM

Bumpation
Reply With Quote
(#13)
Old
amarakak amarakak is offline
Member
amarakak is on a distinguished road
 
Posts: 88
Join Date: Feb 2010
07-23-2019, 10:44 AM

Can do using conditional formatting. send me the spreadsheet I will do
Reply With Quote
(#14)
Old
wasantha99 wasantha99 is offline
Senior Member
wasantha99 is a name known to allwasantha99 is a name known to allwasantha99 is a name known to allwasantha99 is a name known to allwasantha99 is a name known to allwasantha99 is a name known to allwasantha99 is a name known to allwasantha99 is a name known to allwasantha99 is a name known to allwasantha99 is a name known to allwasantha99 is a name known to all
 
Posts: 5,403
Join Date: Jan 2018
07-23-2019, 10:58 AM

bump
Reply With Quote
(#15)
Old
Ek buwa Ek buwa is offline
Senior Member
Ek buwa is on a distinguished road
 
Posts: 299
Join Date: Jun 2018
07-23-2019, 11:45 AM

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.
Reply With Quote
(#16)
Old
ArunaTelshan's Avatar
ArunaTelshan ArunaTelshan is offline
Senior Member
ArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to behold
 
Posts: 2,822
Join Date: Nov 2013
Location: Biyagama
Send a message via ICQ to ArunaTelshan Send a message via Skype™ to ArunaTelshan
07-23-2019, 11:55 AM

https://mega.nz/#!gKpwWQoY!qKVqkpli4...pzn1BQiJUUFcrs

Conditional format walin kalahakine..

https://prnt.sc/oiruaz
Reply With Quote
(#17)
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,597
Join Date: Mar 2017
07-23-2019, 12:10 PM

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.
Reply With Quote
(#18)
Old
ryandok's Avatar
ryandok ryandok is online now
Senior Member
ryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud of
 
Posts: 16,922
Join Date: Oct 2011
Location: වලපල්ලේ
07-23-2019, 12:15 PM

bump
Reply With Quote
(#19)
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,597
Join Date: Mar 2017
07-23-2019, 12:16 PM

Sorry.. I replied while looking only at Page No#1 - only later saw that the member Ek buwa has already posted exactly the same.
Reply With Quote
(#20)
Old
hirugalbandara's Avatar
hirugalbandara hirugalbandara is offline
Senior Member
hirugalbandara is just really nicehirugalbandara is just really nicehirugalbandara is just really nicehirugalbandara is just really nicehirugalbandara is just really nicehirugalbandara is just really nicehirugalbandara is just really nicehirugalbandara is just really nicehirugalbandara is just really nicehirugalbandara is just really nice
 
Posts: 2,356
Join Date: Sep 2014
Location: සිරිකොත
07-23-2019, 01:01 PM

simple
https://support.office.com/en-us/art...b-f1951ff89d7f
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.02505 seconds with 9 queries