This is just a simple example to demonstrate the working way, you could use this method to satisfy your formula and conditions to color the cell border based on the conditional formatting.
![openoffice conditional formatting based on formula openoffice conditional formatting based on formula](https://cxn03651.github.io/write_xlsx/images/conditional_example.jpg)
Select the Border tab and the Outline and then select the color you want to format the cell border with, here I have selected color as green and press OK.Īs you could see the border color of cell that has even number has become green now as intended. Once you click Format, below screen would appear. I have taken the argument as A3 as our data range starts from A3 and the click on the Format button as shown in the figure below. Colour cells with formulas conditionhighlight. Use the conditional formatting formula box for the made up formula. ISEVEN returns TRUE/FALSE depending on whether the value in that cell is even/odd. highlight cells based in formula in Excel. Go to Conditional Formatting section in the Home tab in excel and select New Rule as shown in the pic below.īy clicking New Rule you will get the Formatting Rule box as shown below, select “Use a formula to determine which cells to format” option from the box and enter the formula =ISEVEN(A3) in the formula bar. Select the range of data for which we want to change the border color. all the even number cell border should be green using formula in conditional formatting. Suppose we want to color the cell border of all the even number in the below range to green i.e. We could change the border color of any cell by using conditional formatting using formula. Note - the order of the formula is important because if the first (top) condition is True then none of the others below will even be considered Attachments.
![openoffice conditional formatting based on formula openoffice conditional formatting based on formula](https://i.ytimg.com/vi/cr3DAxer_0E/maxresdefault.jpg)
![openoffice conditional formatting based on formula openoffice conditional formatting based on formula](https://img.yumpu.com/37072414/1/500x640/spreadsheets-a-openofficeorg-calc.jpg)
Using conditional formatting to format the cell border color in excel is as similar as performing any operation using conditional formatting. Click in any cell in the 'D' column and go to 'menu-format-conditional formatting' to see the formulas involved. In this post we will see how could we change the color of cell border by conditional formatting using formula in excel.