We need to highlight in red the information on the projects in progress («Underway»). The task is to highlight the row containing a cell with a certain value.
Conditional formatting of the row by a cell's value Fill in the box as follows:Ĭlick Ok to close the window and view the result. Click «Use a formula to determine which cells to format». Select the range containing the numbers and open the «Highlight Cells Rules» menu. We need the cells with even numbers to be highlighted with a color. The capabilities of this instrument are limitless, so virtually any formula can be used. If the standard rules are not sufficient for the task, the user can apply a formula. Conditional formatting in Excel using formulas The red fill color highlights the cells containing the dates within the past week (the date when this article was written is March 3, 2017). Select the suitable one (for instance, for the last 7 days) and click OK. In the newly-opened window, you can seen the list of available conditions (rules): Conditional formatting of dates in ExcelĪpply «Highlight Cells Rules»-«A Date Occurring» to it.
That is, the number 24, which is simultaneously greater than 6, 10, and 20, is highlighted in accordance with the condition «=$А1>20» (the first one on the list). The highlighting priorities depend on the order of the rules listed in «Rules Manager». Note: the values in some cells simultaneously corresponds to two or more conditions. Likewise, set the second and third formatting conditions: Fill in the formatting parameters for the first condition. Method: Go to the menu of the «Conditional formatting» tool and select «New Rule».In the same way, set the yellow fill color for numbers greater than 20.
Set the formatting condition as «Format cells that are GREATER THAN:» 10, and choose «Green Fill Dark Green Text». In the right one, select «Light Red Fill Dark Red Text». «Highlight Cells Rules» - «Greater Than». We need the numbers that are greater than 6 to be highlighted with red. Conditional formatting – several conditions In the newly-opened window, you can see which rule is applied to which range.