Restart required
2021-12-10
Fix blank screen for users on Windows 10
Open Services with elevated privileges and disable the App Readiness service
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
Subscribe to:
Posts (Atom)