MS Excel

Posted in MS Excel VBA

The lowest and highest value simultaneously formatted

If we have several intervals where we want to highlight, through conditional formatting, the lowest and the highest…

Continuare...
Posted in MS Excel VBA

Worksheet dynamization

I appreciate some features that I have used in specific applications where, for example, the width of a…

Continuare...
Posted in MS Excel Projects VBA

Automatic rounding for a range of cells

If it is desired that, in a sheet, numerical values be formatted and displayed by rounding with a…

Continuare...
Posted in MS Excel

Calculation of work experience, using the DATEDIF function

If an employee record is required, Excel can be used for automatic calculation using the DATEDIF function. Obs:…

Continuare...
Posted in Microsoft Office MS Excel

Conditional Formatting Depending on the Condition of a Column

Conditional formatting adds in the analysis of data from a spreadsheet. To apply a conditional formatting rule on…

Continuare...