Current location - Loan Platform Complete Network - Big data management - excel in two columns of the number to compare how to peer value of small cells to mark, easy to distinguish between
excel in two columns of the number to compare how to peer value of small cells to mark, easy to distinguish between
As an example, A1: C1 there are three numbers, 1, 3, 5,, you want to make 1 the number of cells where the color is marked, is the meaning of this, right, if it is, and A2: C100 is also similar to this, select A1: C100, Format, Conditional Format, Formulas, the box to enter

=MIN($A1:$C1)=A1

Below Pick a format established to return the color, OK.