![openoffice conditional formatting by cell containing openoffice conditional formatting by cell containing](https://img.brainkart.com/imagebk37/7RxxLJr.jpg)
![openoffice conditional formatting by cell containing openoffice conditional formatting by cell containing](https://www.howtogeek.com/wp-content/uploads/2014/04/openoffice-vs-libreoffice.png)
![openoffice conditional formatting by cell containing openoffice conditional formatting by cell containing](https://static.thegeekstuff.com/wp-content/uploads/2011/12/calc-conditional-formatting.png)
I want these icons to be triggered by a boolean (TRUE/FALSE) in another cell. I am only interested in using 1 or 2 icons (a red X for “Off” and a Green light for “On” – not interested in the Yellow light).
OPENOFFICE CONDITIONAL FORMATTING BY CELL CONTAINING HOW TO
Rob emailed me recently, to ask how to limit the conditional formatting icons to 2 colours only, instead of the 3 or 4 default icon colours. For example, use Red, Yellow and Green stoplight icons, to highlight the good, average, and poor results in your sales data. There is a good selection of built-in Excel Conditional Formatting Icon sets. Here’s how to do that, and a workaround to create icons on the worksheet instead. There are built-in icon sets, and in Excel 2010 you can Customize Excel Conditional Formatting Icons, to some extent. In Excel 2007 and Excel 2010, you can use icon sets in conditional formatting.