[Solved] Conditional Formatting - Change cell background

[SnehalS]

Hello Everyone,

My name is Snehal and I have just joined this forum because i wanted some help. I have been using open office (4.1.5 with Mac 10.10.5) recently so have some problems figuring it out.
So here goes. I have an excel and have 11 columns. I want to change the background of a cell based on the values from 2 different columns.
So I have columns A and B which contains yes and no values and column C contains numeric values
So if A$1 = y and B$1 = y then the background for values in column C should become green.
And if A$2 = n and B$2 = n then the background for values in column C should become red.

I have been trying a lot but i am not getting a solution. It will be great if somebody can help. I am attaching the file as well which contains only the three columns.

Thank you. Hope to hear soon.

[FJCC]

In the conditional formatting I used formulas like

Code: Select all   Expand viewCollapse view

AND(B7 = "y"; C7 = "y")

[SnehalS]

Is it possible to keep the formula in A3 and it can be dragged down or copied to the other cells as well. With this I have to do the conditional formatting for every cell. As the data is small there is no issue but when the data is of more rows then that can be an issue.

[FJCC]

You can copy the formatting using Edit -> Paste Special and selecting to paste only the formatting. You can also set the conditional formatting for a range of cells by highlighting the cells, noticing which cell the cursor ends up in, selecting Format -> Conditional Formatting and writing the formula for the cell where the cursor is. The formatting will be adjusted appropriately for the other cells in the range.

[SnehalS]

Okay. Tried and its working. Thank you for the help.

[Zizi64]

Yes, it is possible. But you must delete the nonworking (wrong) conditions from the attached sample files. Then the "copy" and the "drag" will work properly the conditionally formatted cellrange will be expended.

Tested in my LibreOffice 6.1.6 version. (The Conditional Formatting feature is much more advanced in the Libreoffice. you van use more than three conditions, and the manager interface is better: it can show cellranges what will be handled together.)

The fixed sample:

Your sample: