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:
Comments (Atom)