Adding contional formatting to nested SUMIF

[g_kerkelov]

Hi to everyone,

I`m new to this forum so please bear with me. In essence, i was trying to add conditional formatting to SUMIF so differentiate between cells in various colours but can`t work out how go about with entering the colour condition. Has anyone got any suggestions, please?

 

[Akashwani]

Hi and welcome to MrExcel.

If you can provide us with some sample data and your expected results that would be helpful.

You can post sample data by using one of the links in my signature.

You could also take a look here for tips on Conditional Formatting....

Excel Conditional Formatting Introduction

Conditional Formatting | Get Digital Help

Ak

 

[g_kerkelov]

Sorry but i can`t work out how to upload the example in a Excel view.

 

[Akashwani]

Hi,

If you can't upload a sample of your data by using one of the links in my signature, then try to give a clear explanation of the following...

1. The range of cells you are using.
2. An example of the SUMIF formula that you are using.
3. The criteria for the SUMIF formula.
4. The condition that needs to be met for the Conditional Formatting to be applied.

Ak