Steve Lowry
asked on
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?
Is this possible in native Excel 2010, or do I need some VBA programming?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My worksheet is used to record test results. If the technician determines the result entered in the cell is out of specification, they select the cell and press a macro button which changes the fill to red and the font to italic. If certain cells are marked "out of spec", I want to trigger a change in the font color of a cell containing a prepopulated string of text so the message becomes visible.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry I meant 'out of spec' not 'out of sync' :)
ASKER
Thanks for everyone's input.
That seems to be a clever approach and should do the trick. :)