How can I assign the Background color of a particular Cell in an Open Office? Likewise greater the Somevalues should having Green, and less than value should having Red background?
1 Answer
You need Format > Conditional Formatting
from the main menubar.
You need to create a named cell format first, then set the conditions under which this format will apply. See LibreOffice help on this, it works identically in this respect AFAICT (wiki.openoffice.org doesn't have detailed instructions).