![openoffice conditional formatting based on muliple cells openoffice conditional formatting based on muliple cells](https://i.stack.imgur.com/IH0o9.jpg)
In the Text That Contains dialogue box just select Yellow in Format cells that contain the text option and select Light Yellow Fill with Dark Yellow Text option and press OK.Now, to highlight the Yellow text in the sheet do the following after you open the Text That Contain dialogue box. You will get to see the below result after that.In the Text that Contains dialogue box write Red in Format cells that contain the text option and select Light Red Fill with Dark Red Text option and press OK.Under the Highlight Cells Rules option select the Text that Contains option.Now, Under the Home tab select the Conditional Formatting option.First, select the cells from which you want to perform the highlighting.
![openoffice conditional formatting based on muliple cells openoffice conditional formatting based on muliple cells](http://i.stack.imgur.com/mTLZj.png)
Let`s highlight the colors red, yellow, and green from the above list. From them, you want to highlight the colors red, yellow, and green. Let’s say you have some colors in three separate columns. Highlight cells containing specific text using “Highlight Cells Rules”Ĭonditional Formatting makes it easy to highlight the cells which contain some specific text.
#Openoffice conditional formatting based on muliple cells how to#
How to Change Text Color with Formula in Excel.
![openoffice conditional formatting based on muliple cells openoffice conditional formatting based on muliple cells](https://en-academic.com/pictures/enwiki/79/OpenOffice.org_Calc.png)