Data Matches

[Guest]

I have a spreadsheet that looks like the following:

A B C D E F G
1 Cust Prod Jan Feb Mar Apr May (column
headers)
2 A #1 50 45 50
3 A #2 100 100 100 100

The numbers in columns C-G are ASPs of products. I am trying to see if the
ASP changes month over month but there are gaps between the months. Is there
a formula that will compare each column and ignore gaps? Thank you.

 

[Guest]

Have you tried Conditional Formating. Very Useful.

Highlight in yellow when column D doesn't match column A

1) select Cell D2
2) go to Format Menu - conditional formating
3) chan ge cell Value is to formula is
4) add this to the formula

=AND((ISBLANK(D2)=FALSE),(ISBLANK(C2)=FALSE), D2 <> C2)

5) select format - select patterns and pick a color
6) You can then copy this format to other cells by and do a paste specia;l
and sselect format Only.