I have a set of p-values in my spreadsheet in LibreOffice Calc. For the purposes of data analysis, I have written an IFELSE statement that automatically rounds the values to 3 significant figures and replaces any values below 0.001 with the string <0.001.
=IF(H35<0.001, "<0.001", ROUND(H35,3))
Next, I wanted to change all typefaces of values less than 0.05 to bold typefaces, which would of course include <0.001. To do this, I created a formatting style called Bold and which would make bold any values in the cell, plus ensure all numbers had 3 decimal places.
In the conditional formatting, I thus set
Condition 1
Cell value isLess than0.05
Apply Style
Bold
Which works as expected. All values less than 0.05 were made bold. However:
Condition 2
Cell value isContains<
Apply style
Bold
resulted in a nonsensical output where nearly all cells without a < were made bold, and the text <0.001 itself was not made bold. In fact I found out toggling Contains to Not Contains gave me my desired output, which is to bold all values less than 0.05 as well as the string <0.001.
I personally am unable to comprehend this conditional statement and would appreciate it if someone could enlighten me in regards to the issue.