Then in the Home tab, go to Conditional Formatting, click on “ New Rules” select the rule type as “ Use a Formula to determine which cells to format” write the following formula, in formula section. Select the range of cells for your data, like A1:A15. To auto-fill a cell with color in Excel given that it has text in it you can achieve this by applying conditional formatting and selecting a Rule Type for your range of values. In the Equal to the window, you have to delete the value that appears in the box, and then select the cell in this example C3 cell or a specific value in our case 50.Īfter choosing our desired format press OK and A6 cell which equals 50 will be formatted. A drop-down menu will appear to click Highlight Cell Rules and then choose Equal to. In this example, cells A2:A15 are selected, From the Home tab, click the Conditional Formatting command. The cells with values greater than 100 are now colored green, and cells less than 20 are blue.Ĭonditional formatting if it contains a value is equal with 50. In the Format Cells window, click the Fill tab, and click on the green fill color that you want.Ĭlick OK to close the Format Cells window, and click OK to close the Less Than window. In the less than the window, delete the value that appears, and click on cell C2, where the low value is entered.Ĭlick the drop-down list for formats, and click Custom Format. To format the less than values, click highlight cell rules, then click less than. In this example, cells A2:A15 are selected then on the Ribbon’s Home tab, click Conditional Formatting. To color the low values in blue fill, you can apply a second conditional formatting rule to the cells. Conditional formatting if it contains a value less than 20. In the A column could be 100 as a value and using the format we used above the 100 value so it won’t be highlighted, including 100 in highlighted values we should use another format rule. To close the Format Cells window click Ok, the cells with values greater than 100 now are colored green as we choose the color format. To drop down the list for formats click Custom Format, click the Fill tab, and click on the green fill color that you want. In our case A2:A15 is selected. On the Ribbon’s Home tab, click Conditional Formatting, to format the values greater than a specific one select Highlight Cells Rules and then choose the option Greater Than. Turns blue if it contains a value less than 20.Ĭonditional format if a cell contains a value higher than 100.Turns red if it contains a value equal to 50.Turns green if it contains a value higher than 100 and.In the example below, you will set conditional formats so that a cell: If you want to highlight the cell based on a value of a specified cell as criteria, then you can use conditional formatting with a custom formula. There are many ways to use Conditional Formatting, and you can also copy that format to another cell. How to Copy the Conditional Format to Another CellĬonditional formatting is a feature of Excel which allows you to apply a format such as colors, icons, and data bars to a cell or a range of cells based on certain criteria.
0 kommentar(er)
