[libreoffice-users] Conditional formatting in Calc

In a spreadsheet I needed to set the background color in the three cells 
A1, B1, and C1, depending on the value of B1.
Example:
If the cell B1 contains "A" all the 3 cells will be colored. At all 
other values in B1 nothing happens.
In a couple of hours I found a solution, but not in the Help section of 
LibreOffice. Perhaps I just didn't recognize it? Some hidden help :-).
I think there should be something in Help about how to format cells 
ranges depending on the content of one cell. I guess I am not the only 
one who needs this function sometimes.

Curious about the Solution? Here it is:
Select the actual cells range. Open the Conditional Formatting Dialog 
and select condition type "Formula is". As a formula enter (in this 
example) $B1="A". (The $ sign *must* be added). Choose or create a style 
that suits you and press the OK button (or press Enter).

Kolbjoern

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted