Tag Info

Hot answers tagged

3

Use the IF function: =IF(A1=B1, "Yes", "No")


2

Actually, yes, it can be done through conditional formatting... Sort of. Use the screenshots below to setup a conditional format that uses a custom number format for cells that are TRUE. You should be able to extrapolate the setup for False = No. It's important to note that it will only change the apparent value in the cell and not the actual value. If you ...



Only top voted, non community-wiki answers of a minimum length are eligible