Conditional Formatting Question less than greater than

[mcintoshmc]

I'm currently using this formula to format the cell red

SUM($R4+$Y4<4)

It's working fine, but unused rows will have a value of zero, and it's formatting every row on the sheet red because zero is less than 4. Can I do less than 4, but greater than zero?

 

[Marcílio_Lobão]

mcintoshmc, Good evening.

Try to use:

=AND(SUM($R4+$Y4)>0, SUM($R4+$Y4)<4)

Please, tell us if it worked as you want.

I hope it helps.

 

[Joe4]

The SUM is unnecessary and redundant since you are also using the addition (plus) sign. You only need one or the other, not both.
So you can simplify to:

[COLOR=#333333]=AND(($R4+$Y4)>0, ($R4+$Y4)<4)[/COLOR]

 

[mcintoshmc]

That worked!!!! Thank you!

 

[Marcílio_Lobão]

mcintoshmc,

Glad to have helped you.

Thanks for the feedback.