All solutions IF Expert Solution – Excel IF Problems

Excel - IF Function Problem - Expert Solution

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
Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc