Put your Standards in three cells for example cell A1 has the standaerd L.
cell A2 has the standard a. and cell A3 has the standard b. Now put your
color smaple you want to compare to L. in cell B1, a. in cell B2 and the b.
in cell B3. The formula will read
=(((A2-A1)*(A2-A1))+((B2-B1)*(B2-B1))+((C2-C1)*(C2-C1)))^(1/2)

"dragon_girl411" wrote:

I work for a commercial print company and my boss wants me to create a
spreadsheet for reading color data off of press sheets. I need to write a
formula for the DeltaE difference between two colors that are measured in
L*ab. The formula for finding DeltaE is (L1-L2) squared, + (a1-a2)squared,
+(b1-b2)squared; then finding the square root of the total. I just can't
figure out how to use the SUMSQ and SQRT formulas (I'm fairly new to Excel).
Is there anyone out there that can help.