• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1109
  • Last Modified:

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?
0
Steve Lowry
Asked:
Steve Lowry
4 Solutions
 
Roy CoxGroup 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_XResearchCommented:
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
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
@AL_XResearch
That seems to be a clever approach and should do the trick. :)
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Glenn RayExcel 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 LowrySr. 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:
Then all you need is to extend the logic / code for your 'out of sync' test.
1
 
AL_XResearchCommented:
Sorry I meant 'out of spec' not 'out of sync' :)
0
 
Steve LowrySr. ChemistAuthor Commented:
Thanks for everyone's input.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now