Select the cell you want to set, click Conditional Format and set it as Conditional Format.

Enter the IF formula in the B2 table: = IF (A2

Learn the IF function: =if(A, b, c), where a represents the logic to be judged, b represents the value returned when the judgment result of A is true, and c represents the value returned when the judgment result of A is false. If (the content is true, the operation here is performed, otherwise other operations are performed).

Logical_test represents any value or expression that evaluates to TRUE or FALSE. For example, A 10= 100 is a logical expression. What if cells? The value in A 10 is equal to 100, and the expression is? Really, or what? Error. This parameter can use any comparison operator (= (equal to), >; (greater than), > = (greater than or equal to), < = (operator less than or equal to).