Results 1 to 4 of 4
Thread: Ïðàâèëî â Excel
Hybrid View
-
10th October 2014 01:27 #1Registered 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' - äà ñå îöâåòÿâà
-
10th October 2014 08:10 #2Registered User
Join Date: Aug:2009
Location: Ñîôèÿ
Posts: 265
Èçáèðàø A1:A3, Conditional Formatting, New Rule, Use Formula... (òîâà å çà Excel 2010). Ôîðìóëàòà å
Àíàëîãè÷íî çà B1:B3, ñúùàòà ôîðìóëà. Òðåòèÿò ðåä îò ïðèìåðà òè íÿìà äà ñå îöâåòè.Code:=A1<>B1
-
10th October 2014 08:13 #3Registered User
Join Date: Nov:2005
Location: Sofia
Posts: 118
ÎÊ. Ãðåøíî ñúì íàïèñàë çà òðåòèÿ ðåä, ÷å ùå ñå îöâåòè. Íî êàê äà ãî íàïðàâÿ ãëîáàëíî - íå ìè ñå ñëàãà íà n ðåäà.
-
10th October 2014 09:21 #4




Reply With Quote

Íå âúçìîæíîñò äà èçêëþ÷à êîìïþòúðà
7th May 2023, 16:02 in Îáù ôîðóì çà PC õàðäóåð