Results 1 to 12 of 12
Thread: Âúïðîñ çà Excel
Hybrid View
-
14th January 2013 05:02 #1Registered User
Join Date: Oct:2012
Location: Ñîôèÿ
Posts: 12
Âúïðîñ çà Excel
Çäðàâåéòå,
Èìàì åäèí ñïèñúê ñ ïðîäóêòè â åêñåë, êàòî âñåêè ïðîäóêò èìà ñðîê íà ãîäíîñò.
Ùå ñúì ìíîãî áëàãîäàðíà àêî ìîæå íÿêîé äà ìè êàæå êàê äà íàïðàâÿ ïðîäóêòèòå ÷èèòî ñðîê íà ãîäíîñò å èçòåêúë (ñïðÿìî äíåñêàøíèÿ äåí) äà ñâåòâàò â ÷åðâåíî èëè äà ñå ïðèäâèæâàò íàé-îòãîðå èëè ïúê äà ñå ïîÿâÿâàò â äðóãà â äðóãà òàáëèöà?
Áëàãîäàðÿ âè ïðåäâàðèòåëíî
-
14th January 2013 07:09 #2
Ñðîêà íà ãîäíîñò êàê å çàäàäåí?
-
14th January 2013 08:46 #3
Âåðîÿòíî ùå ìîæå äà ñòàíå ñ
now()
è Conditional Formatting.
Íàé-äîáðå å àêî äàäåø ïðèìåðåí ôàéë.Êîëêîòî ïî-ñëîæåí å Êèíåçèòåðàïèÿ - òîëêîâà ïîâå÷å ìúë÷àíèåòî å íà÷èí çà èçðàçÿâàíå.
-
15th January 2013 14:26 #4Registered User
Join Date: Nov:2011
Location: Sofia
Posts: 165
Êàêòî êîëåãàòà íàä ìåí å ñïîìåíàë, èçêàðàé íÿêúäå â òàáëèöàòà ôóíêöèÿ NOW äà òè ïîêàçâà òåêóùàòà äàòà. Ïîñëå âëåç â ìåíþ Conditional Formatting è ìàðêèðàé êîëîíàòà çà êîÿòî äà ñðàâíÿâàø, êàòî è çàäàäåø óñëîâèÿ: ïðè íåéíà äàòà > îò òåêóùàòà è èçáåðåø öâÿò (øðèôò è òí...).
Êîéÿ âðñèÿ íà åêñåë ïîëçâàø, 2003 èëè ïî-íîâà?
-
15th January 2013 14:28 #5
-
15th January 2013 14:32 #6Registered User
Join Date: Nov:2011
Location: Sofia
Posts: 165
-
17th January 2013 14:13 #7GA P35-DS3 | Intel Pentium E6500 | Adata Extreme DDR2 2x2gb 4-4-4-12 / 2x1gb Corsair 4-4-4-12 | HITACHI 1TB Seagate 1TB| ATI Radeon HD 4670 | TEGAN 430




Reply With Quote

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