**Question description:**

*This user has given permission to use the problem statement for this blog.*

Hi, I have a problem with pivot table and conditional formatting please help

Solved by V. C. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
20/03/2018 - 11:46

Hi, please help me!!

Excelchat Expert
20/03/2018 - 11:46

Hi

Excelchat Expert
20/03/2018 - 11:46

Yes please let me know your requirements

User
20/03/2018 - 11:46

Can you see my data?

Excelchat Expert
20/03/2018 - 11:46

yes

User
20/03/2018 - 11:46

Ok great

User
20/03/2018 - 11:47

I need to create a pivot table of this data. Count of lead sources but within specific date ranges

User
20/03/2018 - 11:47

for example I need to see the count of all lead sources from 13th December to 21st January

Excelchat Expert
20/03/2018 - 11:48

ok

Excelchat Expert
20/03/2018 - 11:48

dates you can select in filters of pivot

User
20/03/2018 - 11:49

I need the following

User
20/03/2018 - 11:49

13/12/2017 - 24/01/2018

User
20/03/2018 - 11:49

25/01/2018 - 21/02/2018

User
20/03/2018 - 11:50

22/02/2018 - 20/03/2018

Excelchat Expert
20/03/2018 - 11:50

so in you base data you can tag the dates to be between these range

User
20/03/2018 - 11:50

ok please show me how

User
20/03/2018 - 11:53

:)

User
20/03/2018 - 11:53

What should I do next?

Excelchat Expert
20/03/2018 - 11:53

working on it

Excelchat Expert
20/03/2018 - 11:53

2 min

User
20/03/2018 - 11:53

Oh thankyou

Excelchat Expert
20/03/2018 - 11:56

did you see in spreadsheet?

Excelchat Expert
20/03/2018 - 11:57

using if formula i have specified which date comes on which bucket

Excelchat Expert
20/03/2018 - 11:57

do you get that?

Excelchat Expert
20/03/2018 - 11:57

are you there buddy?

Excelchat Expert
20/03/2018 - 11:57

let me know if you do not understand

User
20/03/2018 - 11:58

Sorry I do not understand

Excelchat Expert
20/03/2018 - 11:58

i have pasted the imporant dates given by you in F2 to K2

Excelchat Expert
20/03/2018 - 11:58

do you see?

User
20/03/2018 - 11:59

yes

User
20/03/2018 - 11:59

where must i paste this?

Excelchat Expert
20/03/2018 - 11:59

you can paste it anywhere any per your requirement

Excelchat Expert
20/03/2018 - 11:59

in column D i have build the formula using those date

Excelchat Expert
20/03/2018 - 11:59

do you see

Excelchat Expert
21/03/2018 - 12:00

to get each and every date in column A into the ranges

User
21/03/2018 - 12:00

Sorry I don't think this is going to work for me

Excelchat Expert
21/03/2018 - 12:00

now when you apply pivot on top of this you will get counts of lead source in this ange

User
21/03/2018 - 12:00

I need it in a pivot table

Excelchat Expert
21/03/2018 - 12:00

why?

Excelchat Expert
21/03/2018 - 12:01

do you know how to use pivot table?

User
21/03/2018 - 12:01

oh okay I see

Excelchat Expert
21/03/2018 - 12:01

now use pivot table on this

Excelchat Expert
21/03/2018 - 12:01

it will be very easy for you now to display counts in these date ranges

Excelchat Expert
21/03/2018 - 12:01

you can also group them when you make pivot table

User
21/03/2018 - 12:02

I see, yes thankyou

Excelchat Expert
21/03/2018 - 12:02

welcome

Excelchat Expert
21/03/2018 - 12:02

do you need any more assistance?

User
21/03/2018 - 12:03

no thankyou very much

Excelchat Expert
21/03/2018 - 12:03

Do let me know of anything else is required

Excelchat Expert
21/03/2018 - 12:03

welcome

Excelchat Expert
21/03/2018 - 12:03

please do give good rating

Excelchat Expert
21/03/2018 - 12:03

it really helps

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*