![]() ![]() 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 |