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
|