formatting output of if statements

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

Guest

Does anyone know of any way to format the output of an if statement? I'm looking to do a very simple if statement and then based on the output I want the text in that cell to come out either green (if true) or red (if false). Thanks!
 
Have a look at condional formatting on the Format menu and have a play.
 
Hi

You can use Conditional Formatting for this (under Data / Conditional
Formatting). See here for an intro to it:
http://www.contextures.com/xlCondFormat01.html

--
Andy.


J.F. said:
Does anyone know of any way to format the output of an if statement? I'm
Click to expand...
looking to do a very simple if statement and then based on the output I want
the text in that cell to come out either green (if true) or red (if false).
Thanks!
 
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

Three possible outputs from an if statement. 3
Getting rid of a VALUE error 5
If statement that outputs specific text if cell is not null 2
If statement for a range of cells 3
Three condition "if" statements 2
Value if an if statement is false 3
Condtional Formatting, Cell Upon Cell 3
If Statement Nesting? 4

Back
Top