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?
Steve LowryPrincipal ChemistAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
AL_XResearchConnect With a Mentor Commented:
Then all you need is to extend the logic / code for your 'out of sync' test.
1
 
Roy CoxConnect With a Mentor Group Finance ManagerCommented:
I think you will need VBA.

Changing a color of a Font won't trigger any worksheet event to run the macro though so how would you want to run the code?

Explain a little more why you need this, there may be a work around
0
 
AL_XResearchConnect With a Mentor Commented:
Can I suggest a different approach ?

Rather than using VBA to check the colour of the trigger cell in order to determine the colour of the target cell (which as Roy_Cox correctly says will require VBA) how about setting your target cell conditional formatting (CF) based on the conditions that originally determine the colour and or font of the trigger cell ?

Sometimes you just need to step back from what you are trying to do.
1
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
@AL_XResearch
That seems to be a clever approach and should do the trick. :)
0
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
@AL_XResearch:
That makes sense, provided that the original referenced cell (A1 in sxlowry's example) is also highlighted based on Conditional Formatting.  If it is manually highlighted, then VBA would be needed.
0
 
Steve LowryPrincipal ChemistAuthor Commented:
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.
0
 
AL_XResearchCommented:
Sorry I meant 'out of spec' not 'out of sync' :)
0
 
Steve LowryPrincipal ChemistAuthor Commented:
Thanks for everyone's input.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.