How to Return the Font Color From Excel Cell

You have received an Excel file and somebody has highlighted text with a different font color? If you are talking about a few cells only – no problem. But what, if you file has hundreds of rows? How do you return the fore color from the text (or number) cells? Method 1: Do it manually… Continue reading How to Return the Font Color From Excel Cell

How to Return the Background Color Code From Excel Cell

Let’s assume the following situation: You have received an Excel file and someone has highlighted different cells. Now you want to read out the different background color codes in order to convert the file into a proper Excel data table. Unfortunately, there is no direct built-in way to solve this. So, let’s see how to… Continue reading How to Return the Background Color Code From Excel Cell