Hi,
I have a workbook with 2 sheets.
Sheet 1- A to I columns. I-coresponds to multiple values of gene ids separated by comma.
sheet2-A to D where A-coresponds to gene ids
D- up or down regulated
1)So I need an indication by either color for each of the multiple values like if it is up-green color or down-red colour.
or
2)Adding two more columns added in sheet1 indicating the up or down regulated
like eg
column I(gene ids)------ UP ---- DOWN
214,815,700,412 ----- 214,700 ----- 815,412

can anyone help me on this? is any of these way possible? and how?
Thanks in advance