Check out FormatConditional Formatting.

Assume a numbers in column A and numbers in column B and a formula in C

=B1-A1 with this formula extending down column C.

Select your 5 cells in each row to be colored, say D1:H1

FormatCF Formula is =C11

Format to a nice color and OK.


Gord Dibben Excel MVP

On Thu, 6 Oct 2005 17:15:08 -0700, ken wrote:

Im new to excel, and dont understand how make a formula to do the following:

First, subtract one cell from another, then if that answer is greater than
1, to highlight 5 cells with a color. I need this to be able to do in
multiple rows.
Any help would be appreciated.