Having Formatting Remain on "Called" cell using IF function

  • Thread starter Thread starter Zaraf
  • Start date Start date
Z

Zaraf

I'm using an IF function to call some other cells, but I want to have
the various words color coded, eg ("Certified" is green, "Recertify" is
yellow, and "Not Certified" is red). I have the IF function working
correctly, but when it "calls" the cell to have it display the
appropriate word, the color of each word is not brought along with
it...only the text. Is there a way to be able to color code it so that
the appropriate color appears? Thanks!
 
Thank you! That worked :) Never even noticed that option there befor
:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2
Automatically change the text format the cell when use a specific text 10
SUMPRODUCT and SUMIFS combined with Sumifbycolor (VBA code) 1
Count of Font Format 1
Changing cell color with a formula? 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
How to color cells based upon a value in another cell 1
How to create a dropdown list that populates with another list 2

Back
Top