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.