Ask Your Question

help with conditional formatting formula..

asked 2020-02-13 04:00:31 +0100

clos911 gravatar image

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!

image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-02-13 06:41:45 +0100

robleyd gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-13 04:00:31 +0100

Seen: 74 times

Last updated: Feb 13 '20