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.
