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