Hello excel forum. I have what I think should be a fairly straightforward Marco, but when I run it, it changes the font color in the referenced cells white instead of dark gray. I deleted the macro I had recorded twice and recorded two additional times and each time I encounter the same issue.
Why doesn't the macro change the font color to dark gray as when I record it?
Attached is the sample worksheet with 2 macros. The "HIDE" button runs the macro that is operating correctly, which hides rows 65 and 66, and changes the font type in rows 63 and 645 from dark gray, unbolded, 10 point font to black, bold, 12 point font.
The Unhide button is supposed to run the macro that reverses what the first Macro did, so I've recorded it to unbold the data in rows 63 and 64, change the font size back to 10 and color from black to dark gray, and unhide rows 65 & 66. The macro does everything correctly, except it changes the font to white instead of dark gray.
Can anyone guide me to the solution to my problem?