Conditional Formatting based on Cell References not Values

**jim2012** · 03-05-2012, 05:27 PM

I have a worksheet that totals data form another sheet. The end user has to copy and paste new rows into this sheet on occasion. I want to do some conditional formatting to be sure the copied row are referencing the correct cells on the "data" sheet.The referenced cells are on the same row. Lets say the Cell references are Sheet1!Z11 and Sheet1!Z25. What I want to achieve is have the Second Cell on my total sheet change color if the cell reference in the second cell is not 14 rows to the right of the first cell reference.

**FDibbins** · 03-05-2012, 06:55 PM

to the right? Not sure I understand what you are trying to achieve, Could you upload a sample file with dummy data in it, showing what you are working with, and what result you are looking to achieve?

**jim2012** · 03-06-2012, 09:32 AM

Attached is a workbook with what i'm trying to accomplish.

**darknation144** · 03-06-2012, 10:35 AM

That is bar near impossible to do as you would have to check if the formula's numbers are equal to the row. Why can't you just get the top line correct and copy down?

Or use Vlookup instead:

test.xlsx

**jim2012** · 03-06-2012, 10:40 AM

I'm not the only user of the workbook. I'm trying to eliminate possible copy errors. So what your saying is there is not easy way to look at the cell reference. Could I Conditional Format to make sure both values(Summery and Data) are equal with an index formula?

**darknation144** · 03-06-2012, 10:51 AM

You could but if you look at my upload you will see you can do it with Vlookup therefore there shouldn't ever be any mistakes. You could use Address(), Row() and Column() to check if you were so inclined. I see you trying to reduce errors but if you use index() or vlookup() user mistakes shouldn't come into it.

**jim2012** · 03-06-2012, 11:11 AM

You're right, I should make the Freight cell Index(), I was making this more complicated the necessarily.
Thanks

Conditional Formatting based on Cell References not Values

LinkBack

Thread Tools

Rate This Thread

Display

Conditional Formatting based on Cell References not Values

Re: Conditional Formatting based on Cell References not Values

Re: Conditional Formatting based on Cell References not Values

Re: Conditional Formatting based on Cell References not Values

Re: Conditional Formatting based on Cell References not Values

Re: Conditional Formatting based on Cell References not Values

Re: Conditional Formatting based on Cell References not Values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions