Automatically Filling Cells

Hi, I am using Libre spreadsheet to monitor my health during this pandemic due to my disabilities. I was wondering if there is a way to set up automatic style fills within the spread sheet when it goes above and below certain numbers. It would make my life easier.

May I assume you enter the cell contents manually (or probably importing from a csv), but want to automatically get shown cell attributes (colors?) like alarm signals?
If so, ConditionalFormatting is what you need to apply.
You may start reading, and then come back with your more specific questions.


i thinks you are looking for the Conditional Formating Feature:

And add one or more conditions with corresponding styles. (This one makes the Cell Red, when the values in the cells are greater or equals 25)

Hope that helps.

To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

Have a nice day and let’s (continue to) “Be excellent to each other!”

Ask / Getting Started:

Thank you for this, it is exactly what I needed as it takes the guess work out of scanning the ideal rates for me.

Happy to help.
Have an awesome day. :slight_smile:

Thanks again because of my health concerns I wanted to start monitoring my health more during this pandemic after I had COVID back in March April to try and take some of the weight from my GPs this helps give me something visual to see when I know I need external help