software

I am trying to run a YTD sales program indexing TY actual weekly sales
against TY Plan sales. The first worksheet shows current year's actual sales
as they update weekly. The second worksheet has the Sales Plan by week for
the entire year. My third worksheet is a simple YTD indexing form to track
YTD sales against YTD Plan. How do I have a cell formatted to only accept
the values in quot;column Bquot; if there is a corresponding value in quot;column Aquot;?
Example: Sales TY in weeks 1-3 vs Plan sales Weeks 1-3; next week 1-4 vs
Plan 1-4, etc.

I don't follow everything you are trying to do, but to answer your literal
question:
You can't format a cell to do that but you can put a formula in a cell to
pick up the Column B value unless Column A is empty. Something like:
=IF(A3=quot;quot;,quot;quot;,B3)

HTH Otto

quot;Mark Kquot; lt;Mark gt; wrote in message
...
gt;I am trying to run a YTD sales program indexing TY actual weekly sales
gt; against TY Plan sales. The first worksheet shows current year's actual
gt; sales
gt; as they update weekly. The second worksheet has the Sales Plan by week
gt; for
gt; the entire year. My third worksheet is a simple YTD indexing form to
gt; track
gt; YTD sales against YTD Plan. How do I have a cell formatted to only accept
gt; the values in quot;column Bquot; if there is a corresponding value in quot;column Aquot;?
gt; Example: Sales TY in weeks 1-3 vs Plan sales Weeks 1-3; next week 1-4 vs
gt; Plan 1-4, etc.