hi
formulas return values, they cannot perform actions such as highlight cells.
but if you put the formula in conditional formating, it would work.
formula is......=IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)...pick your color.

regards
FSt1

"Bookmdano" wrote:

I am comparing data from 2 columns. What I want to do is have a formula that
says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be
done?

Thanks