How can I display certain results in a color font

T

Tracy B

I have a formula that has the potential to display negative numbers, I would
like to highlight these results in a differnt color (as to flag them) is it
in a conditional format?
Thanks

here is my formula
=Master!G62-SUM(DCAC!G63,'787 '!G63,'COC Infra'!G63,'COC SLA'!G63,'FI
Hub'!G63,SONIC!G63,M2A!G63,FTP!G63,Radiance!G63,'Windchill COP'!G63)
 
J

JulieD

Hi Tracey

the easiest option is to select your cell and choose format cells - on the
numbers tab, choose the number category and then select how you want
negative numbers to appear ... if you don't like red, choose custom and type
something like
#,##0;[Blue]-#,##0

substituting blue for whatever colour you want ... (limited range - green /
yellow / magenta seem to work)

Cheers
JulieD
 

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

Auto Update upon shifting, inserting or deleting 2
How do I highlight certain results in an excel formula? 2
How can I set a row to have a different color if it has a +ve val. 1
How can I change font color in search results? 1
how can I edit/change the font color in an excel formula? 1
how can i have certain formulas come up in a specific color 1

Top