Highlight Cells That Equal Excel Formula
If the value in F6 is changed, the highlighting will update automatically. If you want to highlight cells that equal a specific value, you can use a simple formula that returns TRUE when the condition is met. For example, to highlight any cells in the range C5-C11 that contain the text “dog”, you can use conditional formatting with this formula: In the example shown we have placed the value we are looking for in cell F6, so it can be easily changed....