Wording's Colour Change for Logic Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

any1 know how to create "IF" function such that the Value it presents is of
a certain colour for different condition?

E.g.: "=IF(M10>0, "OK", "NOTOK")", "OK" will appear as Green colour wording,
and "NOT OK" as Red colour wording.
 
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

Problems with the Colour Palette in Execel 2003 2
Question about conditional formatting of zeros in Excel 0
Conditional formatting in Excel 2010 2
Data Validation/Conditional Formating 3
Fill Colour problem 2
command button colour 2
Help calculating trend by colours/taking last value per month. Thanks for all efforts 0
Insert text depending on font colour 2

Back
Top