Changing color conditionally

[bhalooneel]

I have this formula in a cell:
=IF(MID(S1,16,1)="6","OK","RECHECK")

Is there a way to make the conditional responses print in different colors? IE, OK in green, and RECHECK in red?

[BrianB]

Use menu Format/Conditional Formatting

[Martin]

Yes, use conditional formatting. Go into Format, Conditional Formatting -
then enter your conditions and formats
--
Regards,

Martin


"bhalooneel" wrote:

>
> I have this formula in a cell:
> =IF(MID(S1,16,1)="6","OK","RECHECK")
>
> Is there a way to make the conditional responses print in different
> colors? IE, OK in green, and RECHECK in red?
>
>
> --
> bhalooneel
> ------------------------------------------------------------------------
> bhalooneel's Profile: http://www.excelforum.com/member.php...o&userid=24023
> View this thread: http://www.excelforum.com/showthread...hreadid=376780
>
>