Microsoft Office Excel 2007,2010,2013, 2016 (Conditional Formatting) Formatare conditionala | Cursuri microsoft
15604
post-template-default,single,single-post,postid-15604,single-format-standard,bridge-core-1.0.6,ajax_fade,page_not_loaded,,qode_grid_1200,qode-theme-ver-18.2,qode-theme-bridge,qode_header_in_grid,wpb-js-composer js-comp-ver-6.0.5,vc_responsive

Microsoft Office Excel 2007,2010,2013, 2016 (Conditional Formatting) Formatare conditionala

Cum pot sa fac formatare conditionala a celulelor in care conditia sa fie "daca au trecut 60 zile de la data ”Data factura””

Conditional Formatting (Formatarea Conditionala), este un instrument puterninc in Microsoft Office Excel iar incepind de la varianta Excel 2007 primeste si forme noi de reprezentare (Data bar, Color Scales, Icon Sets) si dispare limitarea de maxim trei conditii.

image

Se selecteaza zona de celule unde dorim sa apara atentionarea dupa  indeplinirea conditiei.

image

Clic pe butonul Condtional Formatting (Formatare Conditionala), alegeti New Rules

image

Apare Fereastra New Formatting Rule,in care se selecteaza “Use a Formula to determine which cells to format” 1, in zona “Edit the Rule Description: se tasteaza conditia “=AND(TODAY()-$C3>59,COUNT($C3)=1)” 2 (Functia Today() returneaza data din ziua respectiva, data statiei iar in celula C3 avem data facturarii) , clic pe butonul “Format” 3.

image

Apare Fereastra Format Cells, se alege Fill, se alege Rosu, clic Ok.

image

Clic  Ok.

Si apar colorate celulele la care avem mai mult de 60 zile de la data Facturarii.

image

image

No Comments

Post A Comment