I think the problem of not updating would be a problem for the code Misca has suggested as well as for my GET.CELL suggestion, since changing the colour of a cell will not trigger a recalculation of the sheet.How can I automate this function, just like all the others that are built into Excel act? Here is the forum post from last year with the answer I do not quiet understand. Note: If the NOW function does not update cell values when you expect it to, you might need to change settings that control when the workbook or worksheet recalculates.These settings can be changed in Control Panel for the Excel desktop application.You can change the date and time format for the cell by using the commands in the Number group of the Home tab on the Ribbon.
For formulas to show results, select them, press F2, and then press Enter.This might enable you to get the updated data from the sheet without having to manually open it. -Shruti Hello Shruti, Thanks for your very detailed response.I think I have discovered what my issue was originally: I attempted to read an xls file in a Linux environment instead of a Windows environment where MS Office is installed.The function has not been recognized since xl97 or before and there is no 2003, or 2007 equivalent. On the left column of your range write the number the Color Number funcion returns for that color.I got 3 for red, 14 for green and 1 for black so I put those values to the left column and wrote the color names to the right column & named that range (C2: D4) "Colors".