Needing formula to compare values in A1 and B1, and somehow flag the cell if B1 is greater than A1

[paquirl]

Needing formula to compare values in A1 and B1, and somehow flag the cell if B1 is greater than A1

 

[polska2180]

=if(B1>A1,Yes,"")

 

[BigBeachBananas]

Book1
	A	B	C
1	9	12	greater
2	76	46
3	67	47
4	97	57
5	29	25
6	1	43	greater
7	47	50	greater
8	89	1
9	4	66	greater
10	49	38
Sheet1

Cell Formulas
Range	Formula
C1:C10	C1	=IF(B1>A1,"greater","")

 

[Dave Patton]

T202310a.xlsm
	A	B	C
1	900	1000	TRUE
1e

Cell Formulas
Range	Formula
C1	C1	=B1>A1

Consider Conditional Formatting.