Tag Archives: Edit the Rule Description

Cursuri Excel (Conditional Formatting) “20% above or below the expected amount”.

Intrebare: “Hello, I have a table with 4 columns and the last two are represented by Expected Weight Actual Weight. I have to use conditional formatting to highlight (in red) THE ORDER NUMBER for orders which had an actual weight more than 20% above or below the expected amount. can you help me with this?” […]

Microsoft Office Excel 2010, 2007 (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. Se selecteaza zona de celule unde dorim sa apara atentionarea dupa  indeplinirea conditiei. Clic pe butonul Condtional Formatting […]