Hi

I am wondering if it is possible to change the number format of a
column of values depending on a cell that says true or false.

I would like to be able to specify it like a conditional fromat.

I know you can do something in custom number format but as far as I
know this will only evaluate the condition on the current cell value.

Any help would be most appreciated.


--
tmbo
------------------------------------------------------------------------
tmbo's Profile: http://www.excelforum.com/member.php...o&userid=37214
View this thread: http://www.excelforum.com/showthread...hreadid=574469