suppose I have a formula in cell C3:
it will give TRUE:FALSE
but i need Yes:No instead
so how do I format the cell C3 to get so?
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 try to do other calculations based on this cell, it will use the TRUE/FALSE values and not the YES/NO values. Therefore, this method is only helpful for when you're concerned about what's presented to the user and not what's used in underlying calculations.
See how the value would be still be
TRUE but it's displaying "Yes" instead.
=IF(A1=B1, "Yes", "No")
Let me give my two cents.
Supposing you're just interested in the showing values, you may use the following trick.
In C3 insert the formula:
Maybe, get rid off the AND part:
Now, you can set the custom format for
+0 part forces Excel to treat the result as numeric, giving you the option to use the custom format.