Another Simple SUM question

[Larkin.usmc]

Thanks again for the support earlier today.

I'm currently trying to create a SUM conditional format rule to highlight the following cells if they're less than '4'

The cells are =$E$20,$J$20,$L$20,$M$20.

Any assistance is greatly appreciated!

[etaf]

is that the SUM of those 4 cells to be less than "4" or each cell less than "4"

assuming any of the cells

click on E20

for 2007 or 2010 excel version
Conditional Formatting

Highlight applicable range >>
$E$20,$J$20,$L$20,$M$20

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=E20 < 4


Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

OR if its the sum of those cells

use the formula
=SUM($E$20,$J$20,$L$20,$M$20)<4

[Larkin.usmc]

Excellent, that solved my problem immediately.

Thanks again for the outstanding help, it's extremely appreciated!

[etaf]

your welcome

if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here