View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Change text color with an IF statement

Hi Wayne,

Am Tue, 18 Jun 2013 17:34:48 -0400 schrieb WGD:

Within a ROW, entering 'X' let's say in a cell in Column 'M',
change/highlight contents in Column 'N'.


from A1 select all cells in the row(s) that will be formatted. Then
Conditional Formatting = New Rule = Use formula .... and put in this
formula:
=B1="X" and select your wished format.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2