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