Thread: Figuring Out A formula to...

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.

Check out Format>Conditional 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

Format>CF> Formula is =C1>1

Format to a nice color and OK.


Gord Dibben Excel MVP

On Thu, 6 Oct 2005 17:15:08 -0700, ken <ken@discussions.microsoft.com> 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.