![]() If we want to highlight every 2nd column we can use =MOD (COLUMN (), 2) = 0.Similarly, If we want to highlight every third row, we need to change the formula to =MOD (ROW (), 3) =1.On the other hand, if the row number is not divisible by 2, we will get the remainder equal to 1. If the row number is divisible by 2, the remainder will be zero.If the remaining number returned by the MOD function equals number 1, Excel may highlight the row by the mentioned color. read more will return the row number, and the number returned by the ROW function will be divided by 2. The syntax to use this function is as follows: =ROW( Value ). Similarly, the ROW function Excel ROW Function Excel The row function in Excel is a worksheet function that displays the current row index number of the selected or target cell. When we divide the number 3 by 2, we will get 1 as the remainder. The MOD function returns the remainder of the division calculation. This way, Excel formats the particular cells based on the user’s condition. Step 7: Click “OK.” As a result, now, it will highlight all the cells containing the number 5 from A1 to A10.Step 6: Go to the “Fill” option and select the color as per the wish.Step 5: Once the formula is inserted, click on “Format.”.Step 4: In the formula section we must mention = $A1 = 5.Select “Use a formula to determine which cell to format.” Step 3: Now, click on “New Rule.” It will open a separate dialog box. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |