Tag Info

Hot answers tagged


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


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