You can use conditional formatting to create new rules for filling colors. Please refer to the following:

For example, when the value of column A is greater than or equal to 10, the row is filled with yellow.

1, select the whole line from 1 to 10, and start tab- conditional format-new rule;

2. Use the formula to select the cells to be formatted, and enter the formula = $ a1> = 10 (pay attention to the cell reference method);

3. Click Format, select yellow in the Fill tab and confirm;

4. done.