Color line if condition meet in Excel

To color a line if a cell has a specified value go to:

• Conditional Formatting
• New Rule
• Use a formula to determinate witch cells to format
• Format values where this formula is true
• select the cell with the desired value and enter the condition
• select the formatting you want (background color)
• select the whole table

Example:

We have a table with column A to Z and we want to color each row if the cell from column S has the value "Shipped"

Formula should be: =$S1="Shipped" and Applies to =$A:$Z

Excel print to pdf gets the error mandatory field empty

This error occurs when you click on Enable content.

To solve this, you have to go to

Options > Trust Center > Trust Center Settings > Trusted Documents

and click on the Clear button

Excel > Remove duplicate values

• select your list (or active cell is in the list/table)
• go to Data tab and select Remove Duplicates (from the Data Tools group)
• select the desired column and click ok