excel 2013 conditional formating

Is there a way to program a cell so that if I use a certain fill color in that cell the font color in that cell changes to white?
normjayAsked:
Who is Participating?
 
EirmanChief Operations ManagerCommented:
You can put a button on your "Quick Access Toolbar" that runs a macro that applies a style

Make the style and call it say "NormjatStyle1"
Just record yourself applying the style and you have the macro
It could as simple as
Selection.Style = "NormjatStyle1"
0
 
EirmanChief Operations ManagerCommented:
Just create a suitable style.
http://www.dummies.com/how-to/content/how-to-create-a-custom-cell-style-in-excel-2013.html

When you apply the style to a cell(s), the fill colour will be applied with white text.
0
 
normjayAuthor Commented:
Thanks so much Eirman.  Is there a way to put the cell style right on the menu for quick access?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
EirmanChief Operations ManagerCommented:
Yes ...... standby please
0
 
EirmanChief Operations ManagerCommented:
All I can think of at the moment is to right click on one the styles that are always visible in the ribbon
but you don't use
and "Modify" it
0
 
normjayAuthor Commented:
Eirman is extremely knowledgeable and responsive.  His help is very much appreciated.
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.