Hello All,
This is my first post, on any online forum ever, so my apologies if my question has been answered already.
I am working on a very simple budget tracker for someone, in MS Excel 2010. On a list of transactions, each transaction gets assigned to a budget category (Other/Home, Restaurants, Groceries, or Bills). Then, based on what category is selected, all of the text in the transaction's row gets colored a set font color based on a simple string of conditional formatting rules that I set up. As you can see in the first image below, everything has worked up to this point.
Excel Image 1.PNG
What I'm getting hung up on is this. Even though I can clearly see that the conditional formatting has worked, when I click on a cell that's been formatted and then go up to the font color dropdown in the toolbar, Excel is telling me that the font color is black (as seen in the image below). I use a VBA module that sums different values based on their font colors, and this is holding me up. Anyone run into this problem before?
Excel Image 2.png
Thanks for the help,
Joe
Bookmarks