Click «Conditional formatting» - «Highlight Cells Rules» - «Equal To». We will compare the column А1:А11 with the column В1:В11. Let's set the following formatting conditions: compare the values of cells in different ranges and highlight the same values. The values in the А1:А11 range that are less than the value of the B2 cell are filled with the selected color. The formatting result is plain to see in the Excel sheet immediately. In the left box, enter the link to the B2 cell (click on this cell and its name will appear in the box automatically). In this example, let's apply the condition «less» («Highlight Cells Rules» - «Less Than»). Select the initial range and open the window of the «Conditional formatting» tool. Let's compare the values in the range А1:А11 with the number in the B2 cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |