Figuring Out A formula to...

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula or equation 3
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Excel VBA 1
Conditional Formatting For Highlighting a Cell Color 2
need help writing a formula!!! : ) Please I need to write a formulathat will subtract .5 (half an ho 2
Counting occurences of time it takes to calculate to 0 or just ove 2
Formula help 8
Help needed for inexperienced MS Excel 2003 user 2

Top