Can you color code the text result from an IF statement in Excel?

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

Guest

I would like to get color coded response from the IF statement. For example,
if the condition creates a positive number, I would like for it to be in
BLACK. If the condition creates a negative number, I would like for it to be
in RED.
 
You can simply format the cell using a custom format:
<Format> <Cells> <Number> tab, <Custom>
And enter something like this in the "type" box:

#,##0;[red]-#,##0

OR
Find an existing format that has "red" entered after the first semi-colon,
and revise it to suit you.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I would like to get color coded response from the IF statement. For
example,
if the condition creates a positive number, I would like for it to be in
BLACK. If the condition creates a negative number, I would like for it to
be
in RED.
 

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

Back
Top