I am using Libre Office Calc Ver: 25.8.3.2 (x86_64) running on Win10 PC.
First Question
I am using the Conditional formatting a shown below applied to a range of cells S12:S100
Formula is IF(M12="", “”, M12<= $Sheet1.$W$7) Apply Style ConditionalStyle_13
this is the First Condition, the aim of the formula is to fill the cells it is applied to Green if the condition is met (I also use a 2nd condition substituting <= with > to turn cells Red), which it does, however the cells in M12:M100 are formulated for a calculation to 2 decimal places so will never be empty and will show 0.00 if a calculation has not applied, the result is the cells showing 0.00 being less than $Sheet1.$W$7 are all filled Green.
Can the formula be changed so that that cells containing 0.00 are not filled Green.
Second Question
Is it possible to adapt the formula even further so that text appears in S12:S100 along with the colour fill if the condition applies, in case of <= “Yes” and for > “No” I included No for clarity but of course I can alter the formula to suit for No if the concept can be achieved.
PKG gave me the perfect solution with my last question, hoping some knowledgeable saviour will be able to do the same with this one as it beyond my knowledge to find the correct formula.