Now you are able to see days with negative revenues quickly. MS Excel will format the cells you marked in the beginning immediately. For our example “Light red fill with dark red text” is most appropriate.Ĭlick on “OK”. Therefore, click on “Highlight cell rules” and “Less than”.Ĭhose “0” in the field “Format cells that are less than” and decide for a formatting option. For our example, we want to mark cells with a value less than zero with a red background color. This function allows you to change colors of cells based on their value: You can choose between “Less than…”, “Greater than…”, “Between…” and many more options. Mark the cells you want to highlight with colors according to their value.Ĭlick on the tab named “Home” and find the button “Conditional formatting”. To immediately spot negative values, you can highlight these cells using the if-function.Īs a starting point, prepare a list of all your accounting transactions. So, let’s imagine you’re recording accounting transactions. The easiest way to explain how changing the colour of Excel cells via the if-function works is by using an example.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |