Forum Discussion
Help Creating Conditional Formula
I ended up just using the one you sent and manually re-entered everything. My sheet was in the form of a table and I wonder if that was part of the issue.
Ah! I fixed the typo, but the first entry and the third from the bottom in the second image are still not conforming to those rules. Both are dogs with values over 21.
I can't see your actual rules in those rows. My guess is that somehow they're different.
OR, another possibility, depending on how you enter the word "Dog" in column A is that you might have entered "Dog " or some such. Excel is very literal. Blank spaces don't confuse you and me, but they do not look the same to Excel.
If you're not using Data Validation to enter the Dog or Cat value in column A, I highly recommend implementing that.
If you remain stymied, may I suggest that you remove the actual names of the owners and post a copy of the actual spreadsheet without those names. I'll take a look at it and see if I can diagnose and treat. I could then just send you the prescription. (Sorry; couldn't resist.)