Thread: Changing color conditionally
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bhalooneel[_3_] bhalooneel[_3_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote