Thank-you.

Yes, B1 contains a value. I used your suggestion.
Now, is there a way to copy the format from column (B) to (C)?

You guys are great!
--------------------------

"swatsp0p" wrote:


Does B1 currently contain a value? Workbook functions cannot change a
value in another cell. It would take VBA code to do that. You could
enter this formula in C1:

=IF(OR(A1="Dist",A1="Sale"),"--",B1)

Will return the contents of B1 unless A1="Dist" or "Sale"

Then maybe Hide column B

Good Luck.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=486830