I would like to get some help with my assignment. I have to convert hex to binary by using hlookup or conditional formatting in Excel.
How should I approach this?
I would like to get some help with my assignment. I have to convert hex to binary by using hlookup or conditional formatting in Excel. How should I approach this? 


From the Excel Help article Convert numbers to different number systems (specifically, the section Convert a hexadecimal number to binary):



This can be done using Excel's HEX2BIN function. It can be found Here. Excel is a very powerful tool that can do many other things for you. 


This is NOT a complete answer because I gather you are supposed to be learning rather than just copying, but if you know what the possible hex values are (ie not just 09) and you know how to represent these in binary (ie 

