openoffice conditional formatting based on another cell if

Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.Merge Cells/Rows/Columns and Keeping Data Split Cells Content Combine Duplicate Rows and Sum/Average.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by Note: if you want to fill rows when two columns equal, select two lists as range, and then apply the New Formatting Rule dialog. Now the cells have been shaded if two columns equal. Click Format in the New Formatting Rule dialog, then select a background color under Fill tab in the popping Format Cells dialog.Ĥ. Tip: A2 is the first cell in the first list, and B2 is the first cell in the second list you want to compare to.ģ. In the New Formatting Rule dialog, select Use a formula to determine which cells to format from Select a Rule Type section, then type =$A2=$B2 into the text box under Format values where this formula is true. Select the first list of data you want to compare to the second one, for instance, A2:A7, then click Home > Conditional Formatting > New Rule.Ģ. In Excel, you can use the Conditional Formatting function to automatically shade the rows or cells if two columns equal.ġ. It’s a far more efficent way to implement conditional formatting.Method A Conditional formatting rows or cells if two columns equal You can apply one “rule” not only to 1 specific cell, but to a whole range of cells simply by adjusting the cell range. THIS is the correct way to set-up conditional formatting.

On the next line use the drop-down menu again, this time to select your red style.

In the field on the right you type “CHANGE” (including the quotes)

Again it says “Cell value is equal to”.

Use the drop-down menu to select your green style

On the next line it says “Apply Style”.

In the field on the right you type “OK” (including the quotes)

It already says “Cell value is equal to”.

Go to the menu: Format > Conditional Formatting > Manage.

Open your spreadsheet and place the cursor on the cell that requires conditional formatting.

There is a far more easy solution to solve your problem. I read your question and I don’t think the given answer is the best way to achieve what you want.

Openoffice conditional formatting based on another cell if