**Question description:**

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

I would like to add a column by background color, how do I do that?

Solved by C. C. in 20 mins

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

User
26/03/2018 - 09:00

20 min

Excelchat Expert
26/03/2018 - 09:00

hello my name is shah

User
26/03/2018 - 09:01

Hello Shah

User
26/03/2018 - 09:01

I'm Diane

Excelchat Expert
26/03/2018 - 09:01

simply inert column and highlight it

User
26/03/2018 - 09:02

I have inserted the column

User
26/03/2018 - 09:03

I would like to get a total number of either the YES or the backround color

Excelchat Expert
26/03/2018 - 09:03

can you share data

Excelchat Expert
26/03/2018 - 09:04

when yes and when background color?

User
26/03/2018 - 09:04

I have, on the work sheet

User
26/03/2018 - 09:05

I cannot share the complete excel file as it has lots of personal inforamtion

Excelchat Expert
26/03/2018 - 09:06

if you want to calculate total yes simply apply countif function

User
26/03/2018 - 09:06

Can you see the Column that I shared

Excelchat Expert
26/03/2018 - 09:07

yes

User
26/03/2018 - 09:07

I'm not following you

User
26/03/2018 - 09:07

what is the countif function

Excelchat Expert
26/03/2018 - 09:07

countif calculate cell with specfic ceriteria

Excelchat Expert
26/03/2018 - 09:08

and for background conditional formatting

User
26/03/2018 - 09:08

Still not following, I'm really new to excel. can you walk me through how this is done?

Excelchat Expert
26/03/2018 - 09:09

let's see

Excelchat Expert
26/03/2018 - 09:10

if i want to calculate sum of all yes in column i will apply this

Excelchat Expert
26/03/2018 - 09:10

see in worksheet

Excelchat Expert
26/03/2018 - 09:11

cleared

Excelchat Expert
26/03/2018 - 09:12

see cell A105

Excelchat Expert
26/03/2018 - 09:12

are you there?

User
26/03/2018 - 09:13

yes

User
26/03/2018 - 09:13

Thank you

Excelchat Expert
26/03/2018 - 09:14

any objection

User
26/03/2018 - 09:14

That is perfect. Thank you for all you help

Excelchat Expert
26/03/2018 - 09:14

your welcome.

**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.*