IF or CASE in SQL on Excel Sheet

Using VBA in
Excel 2016 64 bit
with
Microsoft.ACE.OLEDB.12.0

Can query 97-2003 Excel File (.xls)
successfully with simple

 SELECT Field1, Field2 FROM [Sheet1$] WHERE .....

But I need to add

If Field3 = 'A' or Field3 = 'B' then 'RED' else 'BLUE' as 'COLUMNNAME'

OR

CASE WHEN Field3 = 'A' or Field3 = 'B' then 'RED'  Else 'BLUE' End as 'COLUMNNAME'