Changing color conditionally
 

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 differen
colors? IE, OK in green, and RECHECK in red

--
bhaloonee
-----------------------------------------------------------------------
bhalooneel's Profile: http://www.excelforum.com/member.php...fo&userid=2402
View this thread: http://www.excelforum.com/showthread.php?threadid=37678

Changing color conditionally
 

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

Changing color conditionally
 

Use menu Format/Conditional Formattin

--
Brian

-----------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...tinfo&userid=5
View this thread: http://www.excelforum.com/showthread.php?threadid=37678