IF-function

  • Thread starter Thread starter Leif
  • Start date Start date
L

Leif

Hi,
is it possible to get the answers in an IF-function in different colors? For
instance, =IF(A1<100,"Yes","No") where the No answer is in red?

I know I can use Conditional formatting but I´d like it within the
IF-function.

Regards
Leif
 
First select the cell with the formula, do format>conditional formatting,
formula is and use

=$A$1>=100

click the format button and select red fonts, click ok twice
 
Thanks Peo, but is it not possible to format within the If-function? And by
the way, could you please send me the Solver example you had used?

Thanks a lot.
 
No it is not possible within the if function, you have to select the cell
with the if function,
do the conditional formatting and use the opposite condition since you
wanted no to be red..
Attached file sent
 

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

Counting the number of rows based on the color 2
Conditional Formating based on Date 5
Excel conditional formatting with Weeknum 4
Change Color of cell 3
IF formula with conditional formating help please 3
Conditional Formating with IF and AND formula 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Alternate Row Coloring 6

Back
Top