Question description:
This user has given permission to use the problem statement for this
blog.
hello, i am a web developer with woocomerce. i am finishing off a large (ish) store and are looking to give him a launch present. I have an excell spreadsheet of the product data, 600 row, 60 columns. I want each cell to have a colour depending on the number held, use as an hex value, i dont mind really. If its text then a one colour, if an empty cell another. I am kind of looking like the DNA of the shop.
Solved by X. D. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/09/2018 - 09:08
Hi
User
12/09/2018 - 09:08
hello, an unsual request
Excelchat Expert
12/09/2018 - 09:08
Could you please share the data?
User
12/09/2018 - 09:09
no upload
Excelchat Expert
12/09/2018 - 09:10
copy paste sample data on the preview sheet on the right
User
12/09/2018 - 09:11
what now
Excelchat Expert
12/09/2018 - 09:12
Please create dummay data on the preview sheet
User
12/09/2018 - 09:12
yea
Excelchat Expert
12/09/2018 - 09:12
Okay, i see the data there
User
12/09/2018 - 09:12
as above
User
12/09/2018 - 09:12
this is more art
User
12/09/2018 - 09:13
i want to give it to the customer as a print
Excelchat Expert
12/09/2018 - 09:13
As per the description, I understood that you want to highligh the cells if it is blank
Excelchat Expert
12/09/2018 - 09:13
right?
User
12/09/2018 - 09:13
colur the cell
User
12/09/2018 - 09:14
if it a numbrt 2698 then the hex value is #269800
User
12/09/2018 - 09:14
if its text yellow
User
12/09/2018 - 09:15
does that make sense?
Excelchat Expert
12/09/2018 - 09:16
I understood the part about text and colour it to yellow
Excelchat Expert
12/09/2018 - 09:16
give me a moment while I implement that
User
12/09/2018 - 09:16
its the DNA of the store
User
12/09/2018 - 09:17
iam shouting this out to @woocommerce happy to add your link and #
Excelchat Expert
12/09/2018 - 09:20
So, i highlighted all the cells that contain text with yellow colour
[Uploaded an Excel file]
Excelchat Expert
12/09/2018 - 09:20
Have a look
Excelchat Expert
12/09/2018 - 09:20
and let me know what else to do
Excelchat Expert
12/09/2018 - 09:26
THERE?
User
12/09/2018 - 09:26
hi
Excelchat Expert
12/09/2018 - 09:26
[Uploaded an Excel file]
Excelchat Expert
12/09/2018 - 09:27
I used conditional formatting to colour cells that contain text
User
12/09/2018 - 09:28
the hex value on the celss with numbers?
Excelchat Expert
12/09/2018 - 09:29
using conditional formatting in excel this is not possible
Excelchat Expert
12/09/2018 - 09:30
based on the values of those cell it can be couloured with a specific colour but there's no option to take the value from a cell and use that value as a colour in cell
User
12/09/2018 - 09:31
ok, thank you
User
12/09/2018 - 09:31
i have another excel project and will be in touch
User
12/09/2018 - 09:31
i will buy a seesion
Excelchat Expert
12/09/2018 - 09:31
great
Excelchat Expert
12/09/2018 - 09:31
thank you
User
12/09/2018 - 09:31
can i check the possiblities quickly though
Excelchat Expert
12/09/2018 - 09:32
sure
User
12/09/2018 - 09:32
i have a cell with a large amount of data
Excelchat Expert
12/09/2018 - 09:32
hat possibilities
Excelchat Expert
12/09/2018 - 09:32
*what
Excelchat Expert
12/09/2018 - 09:32
okay
User
12/09/2018 - 09:32
in the cell are value i want to get from another cell on that row
User
12/09/2018 - 09:33
not merge cells, inject one cell into the contents of another
Excelchat Expert
12/09/2018 - 09:33
I did not follow completely
User
12/09/2018 - 09:33
aaaaaaaaaaaBBaaaaaaaaaaaCCaaaaaaaaaDD
User
12/09/2018 - 09:33
b, c and d are imorted from another cell
Excelchat Expert
12/09/2018 - 09:34
So, do you want to combine multiple cells using formula?
User
12/09/2018 - 09:34
no
User
12/09/2018 - 09:34
one cell has a lot of content
Excelchat Expert
12/09/2018 - 09:34
Extract information form one cell and split into different cells?
User
12/09/2018 - 09:34
within that conent ae values that i would like to merge from another cell
Excelchat Expert
12/09/2018 - 09:35
content of different cells can be combined or split using formula
Excelchat Expert
12/09/2018 - 09:35
Does this answer your question
User
12/09/2018 - 09:36
that what i want
Excelchat Expert
12/09/2018 - 09:36
yes this is possible
User
12/09/2018 - 09:37
is it formula
Excelchat Expert
12/09/2018 - 09:37
yes
User
12/09/2018 - 09:37
so i can copy it easily
Excelchat Expert
12/09/2018 - 09:38
yes
Excelchat Expert
12/09/2018 - 09:38
One minute while I write the formula there
User
12/09/2018 - 09:38
okay, ill buy a session? is that ok
Excelchat Expert
12/09/2018 - 09:38
yes
User
12/09/2018 - 09:40
i bought a monthly sub
Excelchat Expert
12/09/2018 - 09:41
As per the policy, one session is used for solving only one question
Excelchat Expert
12/09/2018 - 09:42
For getting answers to more than one question, you would have to post again
Excelchat Expert
12/09/2018 - 09:42
Meanwhile, in the column D, I have inserted the formula
User
12/09/2018 - 09:43
i need a adjusted
User
12/09/2018 - 09:43
column A
Excelchat Expert
12/09/2018 - 09:44
you want to replace the column A?
User
12/09/2018 - 09:44
as above the cell injected into the content
User
12/09/2018 - 09:45
the value of B" is inserted into the conttent of A2,
User
12/09/2018 - 09:46
the value of B2 is inserted into the content of A2, as shown (B2)
Excelchat Expert
12/09/2018 - 09:46
okay
Excelchat Expert
12/09/2018 - 09:49
Something like in column E
Excelchat Expert
12/09/2018 - 09:49
?
User
12/09/2018 - 09:50
one sec
User
12/09/2018 - 09:51
yes that works for me
Excelchat Expert
12/09/2018 - 09:51
great
User
12/09/2018 - 09:51
aaaa(",C2,")aaa
User
12/09/2018 - 09:51
i just copy that where i need to import a cell?
Excelchat Expert
12/09/2018 - 09:52
yes
User
12/09/2018 - 09:52
cool, great,
User
12/09/2018 - 09:52
thanks
Excelchat Expert
12/09/2018 - 09:52
you are welcome