Not true,

and no real need for VBA

Go to
Format Conditional Formatting

use the drop down box to select formula is

Here you can use any formula to link to a range of other cells or a
single cell

Quick Example
Select th whole column A
go to FC...

formula is =$D1=1, set format as per usual

any corresponding row in column D with value 1 will be formatted.

clevert use of similar relative or fixed referencing does ll the work
for you

hope this helps

http://www.excel-ant.co.uk





gstremer wrote:
Hi all,

Standard conditional formatting of a cell is based solely on the cell's
own value.

Is it possible to make it depend on the value of another cell? I am
not frightened by a VBA solution.

Thanks,

G


--
gstremer
------------------------------------------------------------------------
gstremer's Profile: http://www.excelforum.com/member.php...o&userid=35897
View this thread: http://www.excelforum.com/showthread...hreadid=565239