B bobsmith58d Sep 20, 2004 #1 Anyone know how to make the text change colors, depending on what valu certain data is? I'm sure it's easy...
Anyone know how to make the text change colors, depending on what valu certain data is? I'm sure it's easy...
B BenjieLop Sep 20, 2004 #2 bobsmith58d said: Anyone know how to make the text change colors, depending on what valu certain data is? I'm sure it's easy.... Click to expand... Go to Format/Cells/Custom and inside the "Type" box, choose the forma that will suit your application. Hope this will help you
bobsmith58d said: Anyone know how to make the text change colors, depending on what valu certain data is? I'm sure it's easy.... Click to expand... Go to Format/Cells/Custom and inside the "Type" box, choose the forma that will suit your application. Hope this will help you
M Max Sep 20, 2004 #3 Perhaps conditional formatting would be a better option <g> This example assumes you want to conditionally format an adjacent cell if a certain trigger condition is activated in another "target" cell Assume you want to conditionally format B1 to display the font in red & bolded, if the number in A1 exceeds 10 (A1 will be the "target" cell here) In B1, you might typed have a text-phrase relevant to the number in A1, e.g.: "Alert!" Try this: Select B1 Click Format > Conditional Formatting Under Condition 1, make the settings: Formula Is| =$A$1>10 Click Format button > Font tab > red/bold > OK Click OK at the main dialog The text-phrase in B1 will then appear with font in red & bolded whenever the trigger condition is activated i.e. A1 > 10 (Test this out by inputting some numbers in A1)
Perhaps conditional formatting would be a better option <g> This example assumes you want to conditionally format an adjacent cell if a certain trigger condition is activated in another "target" cell Assume you want to conditionally format B1 to display the font in red & bolded, if the number in A1 exceeds 10 (A1 will be the "target" cell here) In B1, you might typed have a text-phrase relevant to the number in A1, e.g.: "Alert!" Try this: Select B1 Click Format > Conditional Formatting Under Condition 1, make the settings: Formula Is| =$A$1>10 Click Format button > Font tab > red/bold > OK Click OK at the main dialog The text-phrase in B1 will then appear with font in red & bolded whenever the trigger condition is activated i.e. A1 > 10 (Test this out by inputting some numbers in A1)
D Debra Dalgleish Sep 23, 2004 #4 And for some examples of specifying colour in number formats, see Jon Peltier's web site: http://peltiertech.com/Excel/NumberFormats.html
And for some examples of specifying colour in number formats, see Jon Peltier's web site: http://peltiertech.com/Excel/NumberFormats.html
