mcintoshmc
Active Member
- Joined
- Aug 10, 2007
- Messages
- 277
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?
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?