I have numbers in my D Column, I also have numbers in my J column…
I would like to apply a smiley face conditional formatting to my D column starting on the row 3 thru 500 “D3:D500” range…
within the rows,the condition should apply if the number in the D cell plus the number of J cell is more than 200, I would like the sad face to appear.
I have been messing with the formula but It does not seem to work, any suggestions? here is a pic for reference!
You might find How to use Icon Set Conditional Formatting from the LibreOffice Wiki helpful. It has a link to a sample spreadsheet demonstrating the use of conditional formatting with icon sets.
If this answer helped you, please accept it by clicking the check mark 
to the left and, karma permitting, upvote it. That will help other people with the same question.
In case you need clarification, edit your question (not an answer) or comment the relevant answer.
