So, the formula MOD(7,6) returns a value of 1, while MOD(6,7) returns 6.Ī detailed and independent look at Windows 10, especially for Microsoft Office. The ROW function returns the number of the row contained in reference or, if the reference is omitted (as in our example) it returns the number of the row containing the function. ![]() ![]() In Excel, a 0 value equates to FALSE, while any number greater than 0 equates to TRUE. If you find you dont like your chosen color, simply select the range once more, open the Conditional Formatting box and choose another color.įor example, you could set all cells containing negative values to be displayed in a red font. ![]() Yes, theres one auto-format option which gives you this sort of but it comes with unattractive headings and footer formatting and its inflexible.Ĭonditional formatting lets you apply formatting based on the value contained in a cell or based on the result of a formula.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |