Highlight specific color if cell value is between X and Y

dany666 · Post by **dany666** » Sun Dec 11, 2022 6:39 pm

Hi...
I want to set some kind of rule that for ex. numbers between 1-10 will have a background of let's say blue.
Thank you

Post by **Zizi64** » Sun Dec 11, 2022 9:16 pm

Use the Conditional Format feature.

dany666 · Post by **dany666** » Mon Dec 12, 2022 10:45 pm

Um....yes....I've googled a lot before asking for help here....and found stuff about this Conditional Format feature but not how to actually do it...I've done this before a few years ago but i can't seem to remember... short one...I know about the feature but don't know how to use the way that I want

Post by **RoryOF** » Mon Dec 12, 2022 10:54 pm

See the OpenOffice Help file, under Conditional formatting: cells, also conditions.

Highlight specific color if cell value is between X and Y

Highlight specific color if cell value is between X and Y

Re: Highlight specific color if cell value is between X and Y

Re: Highlight specific color if cell value is between X and Y

Re: Highlight specific color if cell value is between X and Y