Ask Your Question

concatenate cells and formating text

asked 2017-09-23 23:26:49 +0100

dimzev gravatar image

updated 2017-10-01 08:58:03 +0100

I have 4 columns A, B.C.D with many rows. Each row have text in only one column.= every time The cells have text on the D column have red color In each row, on G column i use the function (1 row) = A1 &B1&C1&D1 (2 row) = A2 &B2&C2&D2 In cell fro G column i have the text from A or B or C or D column

i want final the results on G columns have red color if take from D column because the print area have only G column

this is my problem my system is: Version: Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2 CPU Threads: 4; OS Version: Linux 4.10; UI Render: default; Locale: en-US (en_US.UTF-8); Calc: group


edit retag flag offensive close merge delete


Concerning formats and styles you won't get happy with alien file formats. Use the native ODF-formats (default extensions .ods, .odt, .odg ...).

Lupp gravatar imageLupp ( 2017-09-24 13:17:44 +0100 )edit

Thank you my Friend !!! I didi it as tou say with .ods Format One more please ... I have many columns ...more of ten and must be red from columns D, F ,K ,M what must write in function ?

dimzev gravatar imagedimzev ( 2017-09-24 16:13:16 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-09-24 01:50:49 +0100

librebel gravatar image

updated 2017-09-24 10:59:53 +0100

Hello @dimzev,

try in column G the following formula:

(this is for in cell G1, then drag the cell handle downwards for the whole range):


The style called "Error" produces a red background and white characters, you can insert your own preferred style here.

EDIT 2017-09-24

Odd, when i opened your xls file in Calc, i immediately got this page:

Cell Style

maybe you don't have a cell style called "Error", please check with a cell style that you have.

You can see your available cell styles via the menu "Format : Conditional Formatting : Condition..." , then click on the dropdown listbox called "Apply Style" . There you can also create a new cell style.

EDIT 2 To create a new Cell Style with a red font:

  1. Click the menu "Format : Styles : New Style...";
  2. In the dialog box that appears, type a name for your new Style, e.g. "Red", and click OK;
  3. Then press F11 to toggle the "Styles and Formatting" panel;
  4. Right-click on your newly created style and select "Modify...";
  5. in the Cell Style dialog that appears, select the tab "Font Effects" and set the Font Color to Red.
edit flag offensive delete link more


take a look to the fille i am upload ..nothing happens

dimzev gravatar imagedimzev ( 2017-09-24 08:51:54 +0100 )edit

please see updated answer with screenshot.

librebel gravatar imagelibrebel ( 2017-09-24 09:25:32 +0100 )edit

i upload aggain , you have right i dont have cell style "Error" , i try to make but as yoy see i cant, can you help me with this step ? *what is EDIT 2017-09-24?

dimzev gravatar imagedimzev ( 2017-09-24 10:10:07 +0100 )edit

EDIT signifies that i edited the post there, now i edited it again, please see EDIT 2.

librebel gravatar imagelibrebel ( 2017-09-24 11:01:46 +0100 )edit

i cant ... i try many times but i cant make it work , perhups something i missing i dont know . Have time to try with skype and teamviewr , skype facebook anything idea?

dimzev gravatar imagedimzev ( 2017-09-24 12:34:49 +0100 )edit

concatenate cells and formating text further question... If i have in one row 2 or more columns with text i need take result the text from last column with formating they have example in th LOupload22: 6 row result must be FG (red) 14 row must be sdf (black) 15 row must be dgg (red) can you help me about this problem ?

dimzev gravatar imagedimzev ( 2017-10-01 09:04:00 +0100 )edit

answered 2017-10-01 13:06:06 +0100

Lupp gravatar image

I don't feel sure about my understanding of the recent comment by @dimzev on the answer by @librebel: Have a look into the attached demo to find the alternatives I considered - and a suggestion how to get the intended results for the interpretation of the question looking most likely to me.

An unsolicited advice: Don't inflate formulae if enhancements are intended. You get clearer structures by using helpers (often columns, sometimes a few cells). Maintenance, scaling, and enhancements often are substantially facilitated this way.

See this attached example.

edit flag offensive delete link more


you have right !! thank you!!

dimzev gravatar imagedimzev ( 2017-10-01 17:02:07 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-23 23:26:49 +0100

Seen: 3,624 times

Last updated: Oct 01 '17