SUMIFs Code

Hi Everyone,

can i change the colour of the cell calculated using SUMIFs?

Thanks in advance

Short answer...nope.

Longer answer...you can use conditional formatting to format based on the result of your SUMIFS function.

If you need more info, then you will need to provide me with more info, such as a sample workbook and a description of what you are trying to achieve.

I hope this helps

Hi ajryan88,

Thanks for the reply. I've attached the sample worksheet.
Notice the code and what I'm trying to achieve is to calculate the sum of plate 1 and 2 and colour the cells that been calculated so that i know which cells are being calculated for plate 1 and 2. the main reason is to double check to avoid any missing data.

Hope you can help me with this. Thanks in advance.

Hmmm,

This isn't quite what I imagined when you said SUMIFS. Why aren't you doing this on the worksheet as an Excel function?

And are you saying you want the cells coloured once they have been included in the sum? Because if so, then this is not possible sorry. Unless you want to use an iterative loop in VBA instead of the SUMIFS, then it can be done, but it is a longer process than a simple SUMIFS.

I hope this helps

Hi ajryan88,

I've attached revised sheet using excel formula. Please take a look at sheet 2. Is it possible with this? Or do you have any suggestion?

There is no Sheet2...

Sorry, my mistake.

Attached new one.

Hi,

That is the right formula, however I'm still not sure what criteria you want the cells coloured from...?

i want to highlight the sum cells if possible.

thanks in advance.

Something like this?

hi,

yes, something like that.
would you mind explain to me the rule you use to format it?

Basically, the rule states that if Column C says "PLANT1" or "PLANT2" (as in your SUMIFS formula), then colour the corresponding sum cell yellow or green (depending on whether it says "PLANT1" or "PLANT2").

I hope this helps

If this solves your problem, please don't forget to mark this thread as solved (Thread Tools --> Mark As Solved), and please click on the * next to my post to say thanks

HI ajryan88,

Thanks a lot for the explaination of the code. Appreciate your help very much!!!
Have a good day!