Message in color

  • Thread starter Thread starter cmlm
  • Start date Start date
C

cmlm

How do I go about returning a message in differant colors.

1st message must be in Blue
2nd message must be in Green
3rd message must appear in Red.

IF(AND(D17>0,D17<=2,"MESSAGE",IF(AND(D17<>"",D17<0),"MESSAGE",IF(AND(D17<>"",D17<1),"MESSAGE","")))

Thank you
 
You can use conditional formatting on the cell that displays the message.
Use the same tests that are in the message formula. For example:

Select the cell that contains the message
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the text box, type: =AND(D17>0,D17<=2)
Click the Format button, and choose the blue font colour
Click OK, then click the Add button.

Create conditions to test for <>"" and <0 (green)
and <>"" and <1 (red)
 
Back
Top