Jump to content








Toggle Scoreboard
ibProArcade Scoreboard

PaTTaaLam PuRushU has obtained a high score of 24 Yesterday, 08:24 PM Playing Candy Tetris Play Now!                InduChOOdaN has obtained a high score of 1232 Yesterday, 07:16 PM Playing Blast Billiards Gold! Play Now!                InduChOOdaN has obtained a high score of 15156 Dec 08 2016 09:20 PM Playing American Idol: Sky Blocks Play Now!                Nehla has obtained a high score of 4376 Dec 08 2016 06:18 PM Playing Sonik Play Now!                dakini17 has obtained a high score of 870 Dec 08 2016 04:08 PM Playing Blocks_2 Play Now!                
Photo
* * * * * 1 votes

Ms Excel ~ Ask Your Doubts And Share Your Tips

MS Excel Excel doubts microsoft excel excel formulaes excel questions microsoft excel doubts

  • Please log in to reply
46 replies to this topic

#2632119 Eda Sureshe

 
Eda Sureshe

    Nokkukutti

  • Star of Star
  • 30,707 posts
  • Location:Neelakasam C/O Soonyakasam
  • Interests:Be an Lone Idle in World of Lonliness
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:34 PM

Hi Friends,

Here Comes a Solution Center for MS Excel Related Querries..

You can Post yous doubts & solutions regarding basic,advanced excel Operations.

Share,Grow with Others

Ms-excel.png

 

 

2015117-175445817-4674-5971581.jpg


  • P.K. Pavanayi, Luttapp!, Benz Vasu and 4 others like this

#2 Benz Vasu

 
Benz Vasu

    Most Affectionate Person of PP

  • Administrator
  • 22,326 posts
  • Location:Uganda
  • Interests:8.75% for 5 Years
    Quarterly compounding
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:36 PM

Suresh oru sambhavam thanne !! 

Jai Jai Suresh :amitt: 




Users Awards

#3 Luttapp!

 
Luttapp!

    Nokkukutti

  • VIP Members
  • 3,966 posts
  • Location:Punchapaadam
  • Interests:Photography
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:39 PM

Inauguration njan thanne aakaam nthaa ..?

nte doubt valare simple aanekilum enikk valare complicated aanu.

 

innu 21 January 2016 aanallo

 

20160120_1404_44.png

 

ithu pole upcoming date automatic aayi highlight akanam athre ullooo :grin:


  • Benz Vasu likes this

#4 Benz Vasu

 
Benz Vasu

    Most Affectionate Person of PP

  • Administrator
  • 22,326 posts
  • Location:Uganda
  • Interests:8.75% for 5 Years
    Quarterly compounding
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:42 PM

Good Qn !! 

ini adutha qn poratte B)




Users Awards

#5 Benz Vasu

 
Benz Vasu

    Most Affectionate Person of PP

  • Administrator
  • 22,326 posts
  • Location:Uganda
  • Interests:8.75% for 5 Years
    Quarterly compounding
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:44 PM

Conditional Formatting vechu cheytha mathiyallo ! :mmm: 




Users Awards

#6 Malar

 
Malar

    ചായക്കട സെക്രട്ടറി

  • Sr Moderator
  • PipPipPipPipPipPipPipPipPipPip
  • 30,563 posts
  • Location:ആഴക്കടലിന്റെ അടിത്തട്ടിലെ പവിഴ കൊട്ടാരത്തിൽ
  • Interests:Music,Rain,Music
  • Gender:Female
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:45 PM

സുരു ടോപ്പിക്ക് തുടങ്ങിയല്ലോ :good: 



#7 Luttapp!

 
Luttapp!

    Nokkukutti

  • VIP Members
  • 3,966 posts
  • Location:Punchapaadam
  • Interests:Photography
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:47 PM

Conditional Formatting vechu cheytha mathiyallo ! :mmm:

conditional formatting-lekk venda formula anu enikk vendathu >> valanja vazhikk njan orennam cheythu but athinu vere columnsil njan formula ezhuthendi vannu.


  • PaTTaaLam PuRushU likes this

#8 PaTTaaLam PuRushU

 
PaTTaaLam PuRushU

    ചായക്കട പ്രസിഡന്റ്

  • Sr Moderator
  • PipPipPipPipPipPipPipPipPipPip
  • 21,132 posts
  • Location:peepeeeee
  • Interests:addict with PP
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:57 PM

conditional formatting-lekk venda formula anu enikk vendathu >> valanja vazhikk njan orennam cheythu but athinu vere columnsil njan formula ezhuthendi vannu.

good question and good doubt..

suru help him



#9 Eda Sureshe

 
Eda Sureshe

    Nokkukutti

  • Star of Star
  • 30,707 posts
  • Location:Neelakasam C/O Soonyakasam
  • Interests:Be an Lone Idle in World of Lonliness
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:57 PM

Inauguration njan thanne aakaam nthaa ..?

nte doubt valare simple aanekilum enikk valare complicated aanu.

 

innu 21 January 2016 aanallo

 

http://s20.postimg.org/6xsflpxvx/2016012...

 

ithu pole upcoming date automatic aayi highlight akanam athre ullooo :grin:

 

 

Which version anu Lutappi ???

 

oru reference kandathu ingananu

Ver: MS 2010

Conditional Formatting > select Manage Rules >> New Rules

 

select Format only cells that contain as the rule type.

Then select Cell Value in the first drop down, less than in the second drop down, and enter the  formula: =NOW()+30 {eg: date after 30 days}

 

Then select what formatting to apply when this condition is met

Then select the color that you'd like to see the dates that will applicable according to the formulae


  • Cuticura AlexandeR, Malar and PaTTaaLam PuRushU like this


Users Awards

#10 Benz Vasu

 
Benz Vasu

    Most Affectionate Person of PP

  • Administrator
  • 22,326 posts
  • Location:Uganda
  • Interests:8.75% for 5 Years
    Quarterly compounding
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:59 PM

conditional formatting-lekk venda formula anu enikk vendathu >> valanja vazhikk njan orennam cheythu but athinu vere columnsil njan formula ezhuthendi vannu.

അങ്ങിനെ ചെയ്യാനേ പറ്റൂ.. 
 
വേറെ ഒരു സെല്ലുമായി കമ്പയര്‍ ചെയ്തിട്ട്, ആ രണ്ടു സെല്ലും സീറോ അല്ല എന്ന് മെന്‍ഷന്‍ ചെയ്തിട്ട്, (=$A2 <> $A1) ഡേറ്റ് റെഫെറന്‍സ് കൊടുത്ത് (=$A2 - TODAY())പിന്നെ ആ രണ്ടു ഡേറ്റ് നെയും വീണ്ടും കമ്പയര്‍ ചെയ്തു (=AND($A2-TODAY()>=0,$A2-TODAY()<=14)) ഒരു കണ്ടീഷണല്‍ ഫോര്‍മാറ്റിംഗ് ചെയ്താല്‍ മതി.
  • Bolt Vinu, Cuticura AlexandeR, Luttapp! and 2 others like this


Users Awards

#11 PaTTaaLam PuRushU

 
PaTTaaLam PuRushU

    ചായക്കട പ്രസിഡന്റ്

  • Sr Moderator
  • PipPipPipPipPipPipPipPipPipPip
  • 21,132 posts
  • Location:peepeeeee
  • Interests:addict with PP
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:59 PM

Which version anu Lutappi ???

 

oru reference kandathu ingananu

Ver: MS 2010

Conditional Formatting > select Manage Rules >> New Rules

 

select Format only cells that contain as the rule type.

Then select Cell Value in the first drop down, less than in the second drop down, and enter the  formula: =NOW()+30

 

Then select what formatting to apply when this condition is met

Then select the color that you'd like to see the dates that will applicable according to the formulae

wow

good answer



#12 Luttapp!

 
Luttapp!

    Nokkukutti

  • VIP Members
  • 3,966 posts
  • Location:Punchapaadam
  • Interests:Photography
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 12:59 PM

MS Office Pro Plus 2010


Sent from my iPhone using Tapatalk
  • PaTTaaLam PuRushU likes this

#13 PaTTaaLam PuRushU

 
PaTTaaLam PuRushU

    ചായക്കട പ്രസിഡന്റ്

  • Sr Moderator
  • PipPipPipPipPipPipPipPipPipPip
  • 21,132 posts
  • Location:peepeeeee
  • Interests:addict with PP
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 01:01 PM

MS Office Pro Plus 2010


Sent from my iPhone using Tapatalk

i think suru's answer is suitable for you

try



#14 PaTTaaLam PuRushU

 
PaTTaaLam PuRushU

    ചായക്കട പ്രസിഡന്റ്

  • Sr Moderator
  • PipPipPipPipPipPipPipPipPipPip
  • 21,132 posts
  • Location:peepeeeee
  • Interests:addict with PP
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 01:01 PM

അങ്ങിനെ ചെയ്യാനേ പറ്റൂ.. 
 
വേറെ ഒരു സെല്ലുമായി കമ്പയര്‍ ചെയ്തിട്ട്, ആ രണ്ടു സെല്ലും സീറോ അല്ല എന്ന് മെന്‍ഷന്‍ ചെയ്തിട്ട്, (=$A2 <> $A1) ഡേറ്റ് റെഫെറന്‍സ് കൊടുത്ത് (=$A2 - TODAY())പിന്നെ ആ രണ്ടു ഡേറ്റ് നെയും വീണ്ടും കമ്പയര്‍ ചെയ്തു (=AND($A2-TODAY()>=0,$A2-TODAY()<=14)) ഒരു കണ്ടീഷണല്‍ ഫോര്‍മാറ്റിംഗ് ചെയ്താല്‍ മതി.

enthandithu thanneya suruvum paranjathu



#15 Eda Sureshe

 
Eda Sureshe

    Nokkukutti

  • Star of Star
  • 30,707 posts
  • Location:Neelakasam C/O Soonyakasam
  • Interests:Be an Lone Idle in World of Lonliness
  • Gender:Male
  • Country: Country Flag
  • Current: Country Flag
 

Posted 21 January 2016 - 01:04 PM

enthandithu thanneya suruvum paranjathu

 

njan paranja method default function use cheythitanu. cell comparison athil automatic varumenu tonunnu. njan athu use cheythu nokeetilla. me using kooduthalum libre office :athe:




Users Awards




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users