Link to home
Start Free TrialLog in
Avatar of Steve Lowry
Steve LowryFlag for United States of America

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?
SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@AL_XResearch
That seems to be a clever approach and should do the trick. :)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steve Lowry

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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sorry I meant 'out of spec' not 'out of sync' :)
Thanks for everyone's input.