I have a spreadsheet that the data is keyed in one cell, then multiple
other cells are populated by the index and match formula being tied to that
entry. My problem is sometimes I need 5 rows populated and other times I
may need 6. Is there a way to have excel show an error if a cell does not
I can see that you can't share file. Can't you even share sample of fake
data? This can help us a lot to understand your query.
On Wed, Feb 20, 2013 at 9:20 PM, solsbee joesolsbe...@gmail.com wrote:
I have a spreadsheet that the data is keyed in one cell, then multiple
other cells are
I would use conditional formatting.
select cell B2
Click Conditional formatting/new rule/Use a formula to determine which
cells to format/.
enter =b2B1
Set the format you want - I used a light green fill
Click OK, OK
Select B2
Copy
Select the rest of column B (or as much of column B as you want
