need help in conditioning formatting

Hi, need help with the conditioning formatting to highlight the cells for every total sum of 125 in two different colors. How do i do that?

sample excel.jpg

Originally Posted by Special-K

What happens if a group of data doesn't total 125 ? if it totals more than 125 ?

Maybe i should use range rather then get a fixed result

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button), as it doesn't work on this forum.

Hope this helps.

Pete

I have attached the excel file that im currently working on. I'm doing the time study and would want to group them into the new group with the total time between 360mins and not more than 400mins.
What formula that i can use to do the grouping in a faster way.

Thanks for the formula.