'Custom formatting of cells linked to a checkbox in Excel
I have a column which is linked to a set of checkboxes. I have figured out how to use conditional formatting to change the color of the cells in the linked column based on the TRUE/FALSE state of their checkbox, but I would also change the text from "TRUE"/"FALSE" to other words, but I can not figure that out. I have tried setting a string under "Number" > "Custom" in conditional formatting but it appears to have no effect. I am guessing this is because they aren't numbers, but I can't find any more suitable place.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|