Data validation on list of boolean values

I seem to have a sort of workaround.
Rather than naming False and True as list options within the data validation dialog box, I can create a named range of two cells on the worksheet, enter False and True into these two cells, and then refer to the list by the name of the range in the data validation. That then allows me to enter values in the cell either by selecting from drop-down list or by typing in False or True. This is the desired outcome but somewhat kludgy, so it is with some reluctance and illfeeling that I feel that I have to flag this thread as "SOLVED".

I've hit too many of these stupid kind of errors to count. Your Validated cell is formatted as Text. Your data list cells are likely General, but they do have the Boolean values of TRUE and FALSE in them.

When you type into the cell you are laying down the English word "True" or "False" as Text so validation fails. When you use the pulldown, you get the Boolean value from the other cell.

Unless you type with caps lock on, you might notice that EXCEL didn't promote True or False to uppercase. Another subtle visual clue is that, in the absence of horizontal formatting, Text cell contents are Left Justified, Boolean centered, and Numeric is Right Justified.

Was it worth waiting 8 years for this awesome answer?