Format Cell Based On Another Cell

Expanding this to the entire row we want to format B7F7 based on the value in D7. In this post I explain how to apply conditional formatting to entire rows in a data range based on the value of a cell in each row matching the value of ano. The process to highlight cells based on the date entered in that cell in Google sheets is similar to the process in Excel. Keep selecting the formula cells and then go to the New Formatting Type dialog box do the following operations.

Excel Formula Conditional Formatting Based On Another Cell Exceljet

To apply conditional formatting based on a value in another cell you can create a rule based on a simple formula.

Format cell based on another cell. Not directly but if the other cells fomatting is set by Conditional Formatting you could test that condition to set the cell color. In the New Formatting Rule dialog box you need to. So lets see how you can make a rule using a formula and after that I will provide a number of formula examples for different tasks.

From the Format Rules section select Custom Formula. First select the entire data from A3E13 as shown below. When we want to format a cell based on the value in a different cell we will use a formula to define the conditional formatting rule.

Select the average column E2E7. Select the cell at Sheet 1 row column 1 and then go to the conditional formatting menu. Select the cell says A1 you want to shade based on another cell value then click Conditional Formatting New Rule.

A2 to A5 is either green or red and if any of those 4 cells are red then the parent A1 needs to be red but if A2 to A5 are all green then A1 wil be green. In the Format Cells dialogue box under the Fill option select the color you want and press OK. B4E12 In the Ribbon select Home Conditional Formatting New Rule.

Conditional Formatting Based On Another Cell Learn How To Apply