Choose the option “Use a formula to determine which cells to format.” In the top nav, click Home, then Conditional Formatting, then New Rule. So if you’re only checking values one character long, you’re good.Īnyway, this is how you do it with conditional formatting in Excel 2007, which is the version I have. It has been seven years since I’ve worked on something like this, and an important caveat I forgot to note is that this formula only checks the first character in a cell. After I got your comment I started playing around with this in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |