2021-12-10

Fix blank screen for users on Windows 10

Open Services with elevated privileges and disable the App Readiness service

Restart required

2021-12-02

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