Results 1 to 4 of 4

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Nov:2005
    Location: Sofia
    Posts: 118

    Ïðàâèëî â Excel

    Êàê ìîãà äà ïðèëîæà ïðàâèëî êîãàòî ñòîéíîñò îò åäíà êîëîíà å ðàçëè÷íà îò ñòîéíîñò â äðóãà êîëîíà äà ñå îöâåòÿâà. Îïèòâàì ñå äà ãî íàïðàâÿ îò conditional formatting ñ èçïîëçâàíåòî íà not equal to, íî íå ìîãà äà ãî íàñòðîÿ äà ñðàâíÿâà 100 ðåäà , à óñïÿâàì äà ãî íàñòðîÿ ñàìî çà åäèí ðåä è äâå êîëîíè.
    Ïðèìåð êàêâî òðÿáâà äà ñòàíå, àêî A1<>B2;A2<>B2;A3<>B3.........:

    A B
    À1 '1' B1 '2 - äà ñå îöâåòÿâà
    À2 '2' B2 '2'
    À3 '3' B3 '3' - äà ñå îöâåòÿâà

  2. #2
    Registered User
    Join Date: Aug:2009
    Location: Ñîôèÿ
    Posts: 265
    Èçáèðàø A1:A3, Conditional Formatting, New Rule, Use Formula... (òîâà å çà Excel 2010). Ôîðìóëàòà å
    Code:
    =A1<>B1
    Àíàëîãè÷íî çà B1:B3, ñúùàòà ôîðìóëà. Òðåòèÿò ðåä îò ïðèìåðà òè íÿìà äà ñå îöâåòè.

  3. #3
    Registered User
    Join Date: Nov:2005
    Location: Sofia
    Posts: 118
    ÎÊ. Ãðåøíî ñúì íàïèñàë çà òðåòèÿ ðåä, ÷å ùå ñå îöâåòè. Íî êàê äà ãî íàïðàâÿ ãëîáàëíî - íå ìè ñå ñëàãà íà n ðåäà.

  4. #4
    Ìúðçåëèâ ïàðàçèò worldoftanks's Avatar
    Join Date: Nov:2010
    Location: Ñòàðà Çàãîðà
    Posts: 3,203
    Quote Originally Posted by niksan05 View Post
    ÎÊ. Ãðåøíî ñúì íàïèñàë çà òðåòèÿ ðåä, ÷å ùå ñå îöâåòè. Íî êàê äà ãî íàïðàâÿ ãëîáàëíî - íå ìè ñå ñëàãà íà n ðåäà.
    Quote Originally Posted by Avis View Post
    Èçáèðàø A1:A3...
    Àìè ùå ìàðêèðàø A1:An

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè