Figuring Out A formula to...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top