I would use conditional formatting.
select cell B2
Click Conditional formatting/new rule/Use a formula to determine which
cells to format/.
enter =b2<>B1
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
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 wrote:
> I have a spreadsheet that the data is keyed in one cell, then multiple
> other cells are populated by the index and m
