Conditional Formatting based on the Color or Font of Another Cell
I want to change the font of one cell based on the color or font of another cell. Example: Cell A1 is given a red fill. This would trigger the change of the color of the font in Cell B2 from black to red.
Is this possible in native Excel 2010, or do I need some VBA programming?