Situatie
The calculation of matrices is one of the most difficult numerical computation tasks. You may need to add values diagonally in a table when performing mathematical computations. Excel allows you to sum diagonal numbers without having to add the values one by one. We’ll go through how to sum cells diagonally down or diagonally up.
Solutie
Pasi de urmat
Step 1: Select the Matrix/Table. Then Go to the home tab & select the conditional formatting option.
Step 2: Choose New Rule.
Step 3: Select: “Use a formula to determine which cells to format” & in the rule description give the format values for the formula. Here we give 1st cell name of the matrix in the formula, i.e., column(B2) – row(B2) (For diagonal)
Step 4: Click on the format. Choose the color, fonts, etc, for formatting & then click on OK.
Step 6: Click on Ok.
Leave A Comment?