btairan.blogg.se

To close the Format cells window click Ok, the cells with values greater than 90 would be colored dark blue as you choose the color format. To drop down the list for formats click Custom Format, click the Fill tab, and click on the blue dark fill color that you want. In the Greater Than window, you have to delete the value that appears in the box, and then select the cell reference, in this example $I$6, or input specific value that is the lowest limit for you. On the Excel 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 dark Blue if it contains a value greater than equal to 90.Turns dark Blue if it contains a value greater than 90.In the example below, you will set conditional formatting so that a cell: Use conditional highlighting to highlight cells less than or greater than a value

This tutorial will show you how with several illustrated examples. If you want to highlight cells based on a value as criteria, then you can use conditional formatting by using a built-in rule and a custom formula.