Turn conditional formatting help pages more friendly

Change-Id: I6511663d80942720c5b9f1053e611f1f5209968c
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/141159
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

6 files changed, 88 insertions, 128 deletions

diff --git a/source/text/scalc/01/05120000.xhp b/source/text/scalc/01/05120000.xhp
index 6e413af55f..180b9f625b 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -30,7 +30,7 @@
       <bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatMenu" id="bm_id5008047" localize="false"/>
       <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/ConditionalFormatDialog" id="bm_id3152518" localize="false"/>
       <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/@@nowidget@@" id="bm_id3152518" localize="false"/>
-      <h1 id="hd_id3155132">Conditional Formatting</h1>
+      <h1 id="hd_id51665407876959"><variable id="ConditionalFormattingh1"><link href="text/scalc/01/05120000.xhp" name="Conditional Formatting">Conditional Formatting</link></variable></h1>
       <paragraph xml-lang="en-US" id="par_id3163710" role="paragraph"><variable id="bedingtetext"><ahelp hid=".">Use <emph>Conditional Formatting</emph> to define range-based conditions that determine which cell style will be applied to each cell in a given range based on its contents.</ahelp></variable> The cell style corresponding to the first condition that evaluates to <emph>true</emph> is applied. Cell styles applied through Conditional Formatting override cell styles applied manually using the <link href="text/scalc/main0202.xhp" name="FormattingBar_link"><emph>Formatting Bar</emph></link> or the <emph>Styles</emph> sidebar.</paragraph>
       <paragraph xml-lang="en-US" id="par_id3163711" role="paragraph">You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If <emph>Condition 1</emph> is true based on the current cell contents, the corresponding cell style is applied. Otherwise, <emph>Condition 2</emph> is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format.</paragraph>
       <paragraph role="paragraph" id="par_id431642031216368">Conditional formats do not overwrite cell styles and direct formatting applied manually. They remain saved as cell properties and are applied when the cell matches no conditions or when you remove all conditional formats.</paragraph>
diff --git a/source/text/scalc/01/05120100.xhp b/source/text/scalc/01/05120100.xhp
index 6e500c3af0..d77d69a0e8 100644
--- a/source/text/scalc/01/05120100.xhp
+++ b/source/text/scalc/01/05120100.xhp
@@ -26,15 +26,13 @@
     <section id="howtoget">
         <embed href="text/scalc/00/00000405.xhp#s_conditionalcondition"/>
     </section>
+    <h2 id="hd_id951665406076405">Conditions for Text and Numbers</h2>
     <table id="tab_id211662913907277">
         <tablerow>
             <tablecell>
                 <paragraph id="par_id181662913907279" role="tablehead" xml-lang="en-US">Condition</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id221663406419144" role="tablehead" xml-lang="en-US" >Applies on</paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id941662913907280" role="tablehead" xml-lang="en-US">Description</paragraph>
             </tablecell>
         </tablerow>
@@ -43,74 +41,97 @@
                 <paragraph id="par_id31662913907282" role="tablecontent" xml-lang="en-US">is equal to</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id321663406539530" role="tablecontent" xml-lang="en-US" ><variable id="numbertext">Numbers and text</variable></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id881662913907284" role="tablecontent" xml-lang="en-US">The cell value equals the user defined value in text box in the right. Use text inside quotes if you compare text values.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id271662914239763" role="tablecontent" xml-lang="en-US" >is less than</paragraph>
+                <paragraph id="par_id831662914760085" role="tablecontent" xml-lang="en-US" >is not equal to</paragraph>
+            </tablecell>
+            <tablecell>
+                <paragraph id="par_id301662914760087" role="tablecontent" xml-lang="en-US" >The cell value is not equal (different) to the user defined value in the text box in the right. Use text inside quotes if you compare text values.</paragraph>
             </tablecell>
+        </tablerow>
+        <tablerow>
             <tablecell>
-                <paragraph id="par_id121663406585137" role="tablecontent" xml-lang="en-US" ><variable id="numbers">Numbers</variable></paragraph>
+                <paragraph id="par_id151662920861587" role="tablecontent" xml-lang="en-US" >begins with</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id501662914239764" role="tablecontent" xml-lang="en-US" >The cell value is strictly less than the user defined value in the text box in the right.</paragraph>
+                <paragraph id="par_id341662920861588" role="tablecontent" xml-lang="en-US" >The cell contents begins with the text or number defined in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id701662914433053" role="tablecontent" xml-lang="en-US" >is greater than</paragraph>
+                <paragraph id="par_id361662922600585" role="tablecontent" xml-lang="en-US" >ends with</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id201663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
-                </tablecell>
-            <tablecell>
-                <paragraph id="par_id461662914433054" role="tablecontent" xml-lang="en-US" >The cell value is strictly greater than the user defined value in the text box in the right.</paragraph>
+                <paragraph id="par_id801662922600586" role="tablecontent" xml-lang="en-US" >The cell contents ends with the text or number defined in the right text box.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id421662914480517" role="tablecontent" xml-lang="en-US" >is less than or equal to</paragraph>
+                <paragraph id="par_id151662922939292" role="tablecontent" xml-lang="en-US" >contains</paragraph>
+            </tablecell>
+            <tablecell>
+                <paragraph id="par_id251662922939293" role="tablecontent" xml-lang="en-US" >The cell contents contains the text or number defined in the right text box.</paragraph>
             </tablecell>
+        </tablerow>
+        <tablerow>
             <tablecell>
-                <paragraph id="par_id301663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
+                <paragraph id="par_id291662923021542" role="tablecontent" xml-lang="en-US" >does not contain</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id631662914480518" role="tablecontent" xml-lang="en-US" >The cell value is less than or equal to the user defined value in the text box in the right.</paragraph>
+                <paragraph id="par_id541662923021543" role="tablecontent" xml-lang="en-US" >The cell contents does not contains the text or number defined in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
+    </table>
+    <note id="par_id801662922586796"><variable id="text_comparison">The condition applies to the internal text conversion of the cell contents. Numeric values are compared with their equivalent text representation. Numeric cell formats (currency, scientific, user-defined ... ) are not considered for comparisons.</variable></note>
+
+    <h2 id="hd_id111665406111372">Conditions on Numbers only</h2>
+    <table id="tab_id321665406132471">
         <tablerow>
             <tablecell>
-                <paragraph id="par_id651662914713102" role="tablecontent" xml-lang="en-US" >is greater than or equal to</paragraph>
+                <paragraph id="par_id991665406132471" role="tablehead">Condition</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id401663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
+                <paragraph id="par_id191665406132471" role="tablehead">Description</paragraph>
             </tablecell>
+        </tablerow>
+        <tablerow>
             <tablecell>
-                <paragraph id="par_id251662914713103" role="tablecontent" xml-lang="en-US" >The cell value is greater than or equal to the user defined value in the text box in the right.</paragraph>
+                <paragraph id="par_id271662914239763" role="tablecontent" xml-lang="en-US" >is less than</paragraph>
+            </tablecell>
+            <tablecell>
+                <paragraph id="par_id501662914239764" role="tablecontent" xml-lang="en-US" >The cell value is strictly less than the user defined value in the text box in the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id831662914760085" role="tablecontent" xml-lang="en-US" >is not equal to</paragraph>
+                <paragraph id="par_id701662914433053" role="tablecontent" xml-lang="en-US" >is greater than</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id501663406628969" role="tablecontent" xml-lang="en-US" localize="false">
-                    <embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
+                <paragraph id="par_id461662914433054" role="tablecontent" xml-lang="en-US" >The cell value is strictly greater than the user defined value in the text box in the right.</paragraph>
             </tablecell>
+        </tablerow>
+        <tablerow>
             <tablecell>
-                <paragraph id="par_id301662914760087" role="tablecontent" xml-lang="en-US" >The cell value is not equal (different) to the user defined value in the text box in the right. Use text inside quotes if you compare text values.</paragraph>
+                <paragraph id="par_id421662914480517" role="tablecontent" xml-lang="en-US" >is less than or equal to</paragraph>
+            </tablecell>
+            <tablecell>
+                <paragraph id="par_id631662914480518" role="tablecontent" xml-lang="en-US" >The cell value is less than or equal to the user defined value in the text box in the right.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id81662914901503" role="tablecontent" xml-lang="en-US" >is between</paragraph>
+                <paragraph id="par_id651662914713102" role="tablecontent" xml-lang="en-US" >is greater than or equal to</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id601663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
+                <paragraph id="par_id251662914713103" role="tablecontent" xml-lang="en-US" >The cell value is greater than or equal to the user defined value in the text box in the right.</paragraph>
+            </tablecell>
+        </tablerow>
+        <tablerow>
+            <tablecell>
+                <paragraph id="par_id81662914901503" role="tablecontent" xml-lang="en-US" >is between</paragraph>
             </tablecell>
             <tablecell>
                 <paragraph id="par_id21662914901504" role="tablecontent" xml-lang="en-US" >The cell value is between the two values defined in the text boxes on the right - lower and upper values - including the boundary values themselves.</paragraph>
@@ -121,9 +142,6 @@
                 <paragraph id="par_id411662915178872" role="tablecontent" xml-lang="en-US" >is not between</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id701663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id861662915178873" role="tablecontent" xml-lang="en-US" >The cell value is not between the two values defined in the text boxes on the right - lower and upper values - including the boundary values themselves.</paragraph>
             </tablecell>
         </tablerow>
@@ -132,9 +150,6 @@
                 <paragraph id="par_id731662915275926" role="tablecontent" xml-lang="en-US" >is duplicate</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id801663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id881662915275927" role="tablecontent" xml-lang="en-US" >The cell and at least one other cell in the range have equal contents.</paragraph>
             </tablecell>
         </tablerow>
@@ -143,9 +158,6 @@
                 <paragraph id="par_id381662915857686" role="tablecontent" xml-lang="en-US" >is not duplicate</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id901663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id341662915857687" role="tablecontent" xml-lang="en-US" >The cell contents is unique in the range.</paragraph>
             </tablecell>
         </tablerow>
@@ -154,9 +166,6 @@
                 <paragraph id="par_id1001662915996409" role="tablecontent" xml-lang="en-US" >is in top N  elements</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id101663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id571662915996410" role="tablecontent" xml-lang="en-US" >The cell value is between the maximum value in the range and the N<sup>th</sup> greater element of the same. Enter the value of N in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
@@ -165,9 +174,6 @@
                 <paragraph id="par_id341662916338175" role="tablecontent" xml-lang="en-US" >is in bottom N  elements</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id111663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id11662916338177" role="tablecontent" xml-lang="en-US" >The cell value is between the minimum value in the range and the N<sup>th</sup> lower element of the same. Enter the value of N in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
@@ -176,9 +182,6 @@
                 <paragraph id="par_id181662916407095" role="tablecontent" xml-lang="en-US" >is in top N percent</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id121663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id911662916407097" role="tablecontent" xml-lang="en-US" >The <emph>cell range index value is in the top N percent</emph> of the number of cells in the range. For example, in a 20 cells range and N equals 20, the style is applied to the 4 last cells of the range. Enter the value of N in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
@@ -187,9 +190,6 @@
                 <paragraph id="par_id421662917285432" role="tablecontent" xml-lang="en-US" >is in bottom N percent</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id121663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id111662917285433" role="tablecontent" xml-lang="en-US" >The <emph>cell range index value is in the bottom N percent</emph> of the number of cells in the range. For example, in a 20 cells range and N equals 20, the style is applied to the 4 first cells of the range. Enter the value of N in the text box on the right.</paragraph>
             </tablecell>
         </tablerow>
@@ -198,11 +198,8 @@
                 <paragraph id="par_id861662917382735" role="tablecontent" xml-lang="en-US" >is above average</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id131663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id811662917382736" role="tablecontent" xml-lang="en-US" >The cell value is strictly greater than the average of the cell range values.</paragraph>
-                <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+                <paragraph role="paragraph" id="par_id701665407334603"><variable id="seenotebelow">See note below.</variable></paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
@@ -210,11 +207,8 @@
                 <paragraph id="par_id421662919561954" role="tablecontent" xml-lang="en-US" >is below average</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id141663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id661662919561956" role="tablecontent" xml-lang="en-US" >The cell value is strictly less than the average of the cell range values.</paragraph>
-                <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+                <paragraph role="paragraph" id="par_id871665407380004" localize="false"><embedvar href="text/scalc/01/05120100.xhp#seenotebelow" markup="ignore"/></paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
@@ -222,11 +216,8 @@
                 <paragraph id="par_id831662919693474" role="tablecontent" xml-lang="en-US" >is above or equal average</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id151663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id71662919693475" role="tablecontent" xml-lang="en-US" >The cell value is greater or equal than the average of the cell range values.</paragraph>
-                <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+                <paragraph role="paragraph" id="par_id871665407380005" localize="false"><embedvar href="text/scalc/01/05120100.xhp#seenotebelow" markup="ignore"/></paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
@@ -234,84 +225,44 @@
                 <paragraph id="par_id521662919771410" role="tablecontent" xml-lang="en-US" >is below or equal average</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id161663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
                 <paragraph id="par_id131662919771411" role="tablecontent" xml-lang="en-US" >The cell value is less or equal than the average of the cell range values.</paragraph>
-                <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
-            </tablecell>
-        </tablerow>
-        <tablerow>
-            <tablecell>
-                <paragraph id="par_id451662919849856" role="tablecontent" xml-lang="en-US" >is error</paragraph>
-            </tablecell>
-            <tablecell>
-                <paragraph id="par_id171663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
-                <paragraph id="par_id911662919849857" role="tablecontent" xml-lang="en-US" >The cell is in the error condition defined in the text box on the right. <link href="text/scalc/05/02140000.xhp" name="calc errors">List of Calc errors</link>.</paragraph>
-                <tip id="par_id61662920733334">A cell that references another cell with an error condition is not in error itself.</tip>
-            </tablecell>
-        </tablerow>
-        <tablerow>
-            <tablecell>
-                <paragraph id="par_id961662920774180" role="tablecontent" xml-lang="en-US" >is not error</paragraph>
-            </tablecell>
-            <tablecell>
-                <paragraph id="par_id181663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
-                <paragraph id="par_id381662920774181" role="tablecontent" xml-lang="en-US" >The cell is not in the error condition defined in the text box on the right. <link href="text/scalc/05/02140000.xhp" name="calc errors">List of Calc errors</link></paragraph>
+                <paragraph role="paragraph" id="par_id871665407380006" localize="false"><embedvar href="text/scalc/01/05120100.xhp#seenotebelow" markup="ignore"/></paragraph>
+
             </tablecell>
         </tablerow>
+    </table>
+    <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+
+    <h2 id="hd_id301665406258582">Conditions on Errors in Cells.</h2>
+    <table id="tab_id1001665406273943">
         <tablerow>
             <tablecell>
-                <paragraph id="par_id151662920861587" role="tablecontent" xml-lang="en-US" >begins with</paragraph>
-            </tablecell>
-            <tablecell>
-                <paragraph id="par_id191663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
+                <paragraph id="par_id451665406273943" role="tablehead">Condition</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id341662920861588" role="tablecontent" xml-lang="en-US" >The cell contents begins with the text or number defined in the text box on the right.</paragraph>
-                <note id="par_id801662922586796"><variable id="text_comparison">The condition applies to the internal text conversion of the cell contents. Numeric values are compared with their equivalent text representation. Numeric cell formats (currency, scientific, user-defined ... ) are not considered for comparisons.</variable></note>
+                <paragraph id="par_id71665406273943" role="tablehead">Description</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id361662922600585" role="tablecontent" xml-lang="en-US" >ends with</paragraph>
-            </tablecell>
-            <tablecell>
-                <paragraph id="par_id201663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
-                <paragraph id="par_id801662922600586" role="tablecontent" xml-lang="en-US" >The cell contents ends with the text or number defined in the right text box.</paragraph>
-                <note localize="false" id="par_id221662923585290"><embedvar href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note>
-            </tablecell>
-        </tablerow>
-        <tablerow>
-            <tablecell>
-                <paragraph id="par_id151662922939292" role="tablecontent" xml-lang="en-US" >contains</paragraph>
+                <paragraph id="par_id451662919849856" role="tablecontent" xml-lang="en-US" >is error</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id211663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
-            </tablecell>
-            <tablecell>
-                <paragraph id="par_id251662922939293" role="tablecontent" xml-lang="en-US" >The cell contents contains the text or number defined in the right text box.</paragraph>
-                <note localize="false" id="par_id221662923585291"><embedvar href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note>
+                <paragraph id="par_id911662919849857" role="tablecontent" xml-lang="en-US" >The cell is in the error condition defined in the text box on the right. See <link href="text/scalc/05/02140000.xhp" name="calc errors">List of Calc errors</link>.</paragraph>
             </tablecell>
         </tablerow>
         <tablerow>
             <tablecell>
-                <paragraph id="par_id291662923021542" role="tablecontent" xml-lang="en-US" >does not contain</paragraph>
-            </tablecell>
-            <tablecell>
-                <paragraph id="par_id221663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
+                <paragraph id="par_id961662920774180" role="tablecontent" xml-lang="en-US" >is not error</paragraph>
             </tablecell>
             <tablecell>
-                <paragraph id="par_id541662923021543" role="tablecontent" xml-lang="en-US" >The cell contents does not contains the text or number defined in the text box on the right.</paragraph>
-                <note localize="false" id="par_id221662923585292"><embedvar href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note>
+                <paragraph id="par_id381662920774181" role="tablecontent" xml-lang="en-US" >The cell is not in the error condition defined in the text box on the right. See <link href="text/scalc/05/02140000.xhp" name="calc errors">List of Calc errors</link></paragraph>
             </tablecell>
         </tablerow>
     </table>
+    <tip id="par_id61662920733334">A cell that references another cell with an error condition is not in error itself.</tip>
+    <section id="relatedtopics">
+        <paragraph role="paragraph" id="par_id471665407993996"><embedvar href="text/scalc/01/05120000.xhp#ConditionalFormattingh1" markup="ignore"/></paragraph>
+    </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/05120200.xhp b/source/text/scalc/01/05120200.xhp
index 0ca1663721..ebb624f728 100644
--- a/source/text/scalc/01/05120200.xhp
+++ b/source/text/scalc/01/05120200.xhp
@@ -11,16 +11,19 @@
 
     <meta>
         <topic id="pageconditionalformattingformulais" indexer="include" status="PUBLISH">
-        <title id="tit" xml-lang="en-US">Conditional Formatting - Formula is</title>
-        <filename>/text/scalc/01/05120200.xhp</filename>
-    </topic>
-</meta>
-<body>
-<section id="formulais">
-    <h1 id="hd_id471662936567369"><variable id="h1"><link href="text/scalc/01/05120200.xhp" name="Formula is">Condition - Formula is</link></variable></h1>
-    <paragraph xml-lang="en-US" id="par_id31494139" role="paragraph">Applies the selected style to the cell when the formula expression in the text box in the right is <emph>not</emph> zero.</paragraph>
-</section>
+            <title id="tit" xml-lang="en-US">Conditional Formatting - Formula is</title>
+            <filename>/text/scalc/01/05120200.xhp</filename>
+        </topic>
+    </meta>
+    <body>
+    <section id="formulais">
+        <h1 id="hd_id471662936567369"><variable id="h1"><link href="text/scalc/01/05120200.xhp" name="Formula is">Condition - Formula is</link></variable></h1>
+        <paragraph xml-lang="en-US" id="par_id31494139" role="paragraph">Applies the selected style to the cell when the formula expression in the text box in the right is <emph>not</emph> zero.</paragraph>
+    </section>
     <paragraph role="paragraph" id="par_id1001662932287796">The formula is expressed similar to a test condition evaluating to <literal>TRUE</literal> or <literal>FALSE</literal>.</paragraph>
     <paragraph role="paragraph" id="par_id111662936728630">For example, if C29 has a conditional formatting which formula is <input>B1>=(DATE(2015;5;4)+TIME(18;0;0))</input> - a logical expression that evaluates true or false - the style applied to C29 depends on B1 contents.</paragraph>
-</body>
+        <section id="relatedtopics">
+            <paragraph role="paragraph" id="par_id471665407993996"><embedvar href="text/scalc/01/05120000.xhp#ConditionalFormattingh1" markup="ignore"/></paragraph>
+        </section>
+    </body>
 </helpdocument>
diff --git a/source/text/scalc/01/05120300.xhp b/source/text/scalc/01/05120300.xhp
index 3ed829c795..0f00cefb5b 100644
--- a/source/text/scalc/01/05120300.xhp
+++ b/source/text/scalc/01/05120300.xhp
@@ -47,5 +47,8 @@
             <paragraph id="par_id461662934605639"  role="listitem"><emph>This year, Last year and Next year</emph>: applies the cell style if the cell date contents is in this year, last year and next year respectively.</paragraph>
         </listitem>
     </list>
+    <section id="relatedtopics">
+        <paragraph role="paragraph" id="par_id471665407993996"><embedvar href="text/scalc/01/05120000.xhp#ConditionalFormattingh1" markup="ignore"/></paragraph>
+    </section>
 </body>
 </helpdocument>
diff --git a/source/text/scalc/01/05120400.xhp b/source/text/scalc/01/05120400.xhp
index c5e90c644c..9fc6ceabff 100644
--- a/source/text/scalc/01/05120400.xhp
+++ b/source/text/scalc/01/05120400.xhp
@@ -236,6 +236,7 @@
     <embed href="text/scalc/01/05120400.xhp#commonconditions"/>
     <embed href="text/scalc/06/calcsamplefiles.xhp#conditionalformatting"/>
     <section id="relatedtopics">
+        <paragraph role="paragraph" id="par_id471665407993996"><embedvar href="text/scalc/01/05120000.xhp#ConditionalFormattingh1" markup="ignore"/></paragraph>
         <paragraph xml-lang="en-US" id="par_id3155606" role="paragraph"><link href="https://wiki.documentfoundation.org/Faq/Calc/141">How to use Icon Set Conditional Formatting page</link> in TDF Wiki.</paragraph>
         <paragraph role="paragraph" id="par_id651663598549283"><link href="https://wiki.documentfoundation.org/Faq/Calc/142">How to apply a Color Scale Conditional Formatting page</link> in TDF Wiki.</paragraph>
     </section>
diff --git a/source/text/scalc/01/05120500.xhp b/source/text/scalc/01/05120500.xhp
index 6706c1c2f8..8f74e1418a 100644
--- a/source/text/scalc/01/05120500.xhp
+++ b/source/text/scalc/01/05120500.xhp
@@ -31,6 +31,8 @@
     <paragraph xml-lang="en-US" id="par_id3155909" role="paragraph">The <emph>Conditional Formats</emph> list displays the active conditional formatting rules set in the current spreadsheet. Only the first rule for each cell range is listed, even if there are multiple rules defined for a given range.</paragraph>
 
     <paragraph xml-lang="en-US" id="par_id3155908" role="paragraph">If you have defined a conditional formatting on a cell range and you try now to define a new conditional formatting on a part of this range, a warning message will be displayed, asking if you want to edit the existing conditional formatting (on the whole range) or define a new conditional formatting overlapping it (on the selected range).</paragraph>
-
+    <section id="relatedtopics">
+        <paragraph role="paragraph" id="par_id471665407993996"><embedvar href="text/scalc/01/05120000.xhp#ConditionalFormattingh1" markup="ignore"/></paragraph>
+    </section>
 </body>
 </helpdocument>