Re: Conditionally format a column conditionally format a column values of another column

Yes, just use a formula such as

=$C1<>0


assuming that the CF is in A1:An, and the values are in C


----- Original Message ----- 
From: "Tony Lau" <tonylauLEGENDS4.COM>
To: <EXCEL-GPEACH.EASE.LSOFT.COM>
Sent: Wednesday, March 28, 2007 11:08 PM
Subject: Conditionally format a column conditionally format
a column values 
of another column


> Is there a way to conditionally format a column of
cells based on the
> corresponding non-zero values of another column?
>
> Thanks in advance!
>
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                             COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>
> __________ NOD32 2152 (20070328) Information
__________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
> 

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G