Proficiency in Microsoft Excel is a skill that will add weight to your CV. However, most people who claim to be proficient in Excel do not know many things about it. For instance, there will be fewer people who would know how to change cell color based on the value of another cell in the Excel sheet. If you know how to do it then great if not, this article is for you to read.
How to Change Cell Colour Based on Value of Another Cell in Excel Sheet:
The first thing you need to know is that you will need to use Conditional Formatting to get this job done. You can use the conditional formatting feature to create a formatting formula which will help you to achieve your objective. To build this basic formatting rule, follow these steps:
1. Open the Excel File that you want to make changes to. Now select the data cells in your target range.
2. Next, click on the option Home followed by clicking on the option Conditional Formatting. Choose the option New Rule from the list of options available.
3. A dialog box will appear on the screen with a few options on it. Choose the option Use a Formula to Determine which Cells to Format.
4. Now key in the formula (depending on your data and preference) and it should follow the right format. The only thing you need to keep in mind is that the formatting formula needs to be set up so that it returns a true or false value. If the formula return true (for the value comparisons) then the condition would be applied and vice versa.
5. Importantly, you need to keep in mind is that the active cell is the reference point for the formula and colors will be changed only if the formula returns true for this reference point.
6. Once you enter the formula, click on the option Format to specify the desired format. You will be able to change fonts, colors, borders and whatnot for the selected cells.
7. You will see the cells change color (or any other formatting applicable) as soon as you hit the option OK.
Reading this article will make you think that it is quite a difficult job. In reality, it is all about executing it properly for the first time, and then you will master it. Remember, having the ability to format a cell based on the value of another cell is quite handy, and it will help you a lot if you are working in any finance department.